Back to all posts
Power BI

ALLSELECTED Function in Power BI

ALLSELECTED : The ALLSELECTED function in DAX is used to return all the rows in a table, or all the values in a column . This is particularly useful in sce…

Author

SQLDataDev Editorial Team

Mar 19, 2026 1 min read

ALLSELECTED: The ALLSELECTED function in DAX is used to return all the rows in a table, or all the values in a column. This is particularly useful in scenarios where you want to apply calculations that consider the currently selected rows or values in a report visual.

SQL 
Total Sale (ALL) = CALCULATE(
                    SUM(SalesTable[Amount]),
                    ALL(SalesTable)
                )

Total Sale (ALLSELECTED) = CALCULATE(
                    SUM(SalesTable[Amount]),
                    ALLSELECTED(SalesTable)
                )

Total Sale (REMOVEFILTERS) = CALCULATE(
                    SUM(SalesTable[Amount]),
                    REMOVEFILTERS(SalesTable)
                )

Topics covered

Power BI

Keep building your data skillset

Explore more SQL, Python, analytics, and engineering tutorials.

Browse All Posts