Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure not ignoring slicer

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

 

TypeData Value
f2f1
phone1
CFD1
CFD1
Apple1
Virtual1
Need Help
  • Thejeswar's avatar
    Thejeswar
    4 years ago

    Hi Anonymous ,

    Can you clarify on this?

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

     

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Thejeswar
      Icon for Super User rankSuper User
      4 years ago

      Hi Anonymous ,

      Can you clarify on this?

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