Create slicer if values of two measures are not zero

[PrieleBI]

Hello,

I have measure A and measure B.

I need to filter fact table, that there would left only those categories, that measure A <> blank and measure B <> blank.

I cant make calculated table or Dimtable, because the fact table should be filtered dynamically, according to other slicers selected.

How to create slicer from these two measures evaluation by category?

Fact table:

Category	Measure A	Measue B	Commnt
a	10
b	5	90	Both measures values <> blank
d	6
d	4
g		60
j	6	5	Both measures values <> blank
t		6

[jdbuchanan71 · Accepted solution]

You can put your Category on a slicer and apply a fitler to the slicer for [Measure A] is not blank and [Measure B] is not blank.