Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

filter for slicer

Hey,

I would like to apply a filter for a slicer field in the following way:

In table 1 I have an "id" column and a  boolean column "a". If a =True, the corresponding id should appear in the slicer. Else the 

id should be excluded rom the slicer. In the slicer the data is from table 2 which is identical to table 1.

I need to create a measure and then drag it into the filter field of the slicer, right? Can you help me how to implement the measure in DAX?

 

Thanks,

Susanne

 

Need Help
  • DS12345's avatar
    DS12345
    6 years ago

    Hi Susanne,

     

    A measure could be the solution. Measure = IF(a=true, 1, 0)

    Then add this measure as a filter to the slicer and select measure = 1

     

    Hope this solves your problem.

     

     

1 Reply

  • DS12345's avatar
    DS12345
    Frequent Visitor
    6 years ago

    Hi Susanne,

     

    A measure could be the solution. Measure = IF(a=true, 1, 0)

    Then add this measure as a filter to the slicer and select measure = 1

     

    Hope this solves your problem.