Select all from filter to include in DAX Calculation

[Anonymous]

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

[SivaMani · Accepted solution]

@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-dax

You can use this function for overall condition, IF( NOT(ISFILTERED(Region)), A+B)