Syntax
ALLSELECTED([<tableName> | <columnName>])
Tutorial with example
In this video we will go through how to to use ALLSELECTED function in DAX.
Download example file:
Download Power BI file (Part 1): here.
No download file available for the sumif video. Please use the northwind dataset to practice.
Remarks
- This function takes one or no arguments. If there is one argument, the argument is either tableName or columnName.
- This function is different from ALL() because it retains all filters explicitly set within the query, and it retains all context filters other than row and column filters.
[Total: 4 Average: 4/5]
« Back to Index
How can i use ALLSELECTED with calculatetable DAX Function ?
Hi Abhi,
I will do a video on it in future DAX Fridays series.
/Ruth