Forum Discussion
Select all from filter to include in DAX Calculation
Hello All,
I have report where I have 2 tables data A and B.
So here i have field called Region with values EMEA and APAC from both the tables.
I have a filter on Region
Here is my dax calculation for a measure
If region ='EMEA' then TableA.Field1
elseif region ='APAC' then TableB.Field1
elseif Overall then TableA.Filed1+TableB.Field1
In my Region filter I am getting EMEA ,APAC and Select All options
Here my confusion is like how I need to get the overall condition
When the user selects 'Select all' from filter I have to sum both the fields from A and B
Could any one please help
Anonymous , Select All is nothing but no filter. There is a DAX function that returns whether the table or column is directly filtered - ISFILTERED()
https://docs.microsoft.com/en-us/dax/isfiltered-function-daxYou can use this function for overall condition, IF( NOT(ISFILTERED(Region)), A+B)
1 Reply
SivaManiResident Rockstar
Anonymous , Select All is nothing but no filter. There is a DAX function that returns whether the table or column is directly filtered - ISFILTERED()
https://docs.microsoft.com/en-us/dax/isfiltered-function-daxYou can use this function for overall condition, IF( NOT(ISFILTERED(Region)), A+B)