Measure not ignoring slicer

[Invesco]

Hi Experts

The following measure should always return back 2 irrespective of what as been selected in the sclier (CFD is not included in the sclier) - so if te user selects f2f from the sclier then the below measure returns 2 as there are 2 CFD values in the date range.... i keep on getting 1 if i select f2f and 1 for phone  and 1 for virtual... as Days count....

Days # =

Calculate(SUM(table1[data_value]),

FILTER(ALL(table1[activity_type_1]),

table1[activity_type_1] = "CFD"))+0

Type	Data Value
f2f	1
phone	1
CFD	1
CFD	1
Apple	1
Virtual	1

[v-henryk-mstf]

HI @Invesco,

I’d like to suggest you take a look at the following link about all functions, they can be used to ignore specific filter effects.

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT 

Regards,

Xiaoxin Sheng

[Invesco]

when i select ALL the measure works - however when i select the indivdual Type then it does not return the correct value for CFD... i have one fact table in the model and not date table as everything works of the FACT table fine

[Thejeswar · Accepted solution]

Hi @Invesco ,

Can you clarify on this?

I tried using the same measure that you have created, it is returning 2 even with slicers selected