Useful for showing visual totals, this DAX function discards filters that come from a visual's row and column headers yet respects outside filters such as slicers; ALL, by comparison, would clear the slicer filters as well.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains ALLSELECTED in context, with comparison tables and the common traps.
Terms in this definition
- DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
- ALL
A DAX function that ignores any filters and gives back every row of a table or every value of the named columns. Used within CALCULATE, it works as a modifier that clears filters, although REMOVEFILTERS states that intent more clearly where it is available.
- Slicer
Placed directly on a Power BI report page, this filter control narrows the other visuals on that page; it can appear as buttons, a list, a drop-down or a date range.