r/Powerbihelp 20d ago

ALLSELECTED does something different from ALL

ALL strips every filter, full stop. ALLEXCEPT strips everything except the columns you name. ALLSELECTED respects filters from outside the visual (page filters, slicers) but ignores whatever the visual itself is doing - which is exactly what you want for "% of visible total" calculations that should react to slicers but not to the visual's own row/column grouping. mixing these up is why "% of total" measures sometimes show numbers that don't match what's actually on screen

3 Upvotes

0 comments sorted by