filter for slicer

[Anonymous]

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

[DS12345 · Accepted solution]

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.