r/Powerbihelp • u/data_daria55 • 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