If and Slicer filters

[ecmsev]

Hi all,

I would like to use an IF function and not apply a measure and get blank if one or two of the slicers have filters selected.

How could I do that?

Best regards

[v-frfei-msft · Accepted solution]

Hi @ecmsev ,

One sample for your reference, here I create a measure using HASONEVALUE to work on it.

Measure = 
VAR A =
    HASONEVALUE ( Table1[SLICER1] )
VAR B =
    HASONEVALUE ( Table2[SLICER2] )
RETURN
    IF (
        A = TRUE ()
            && B = TRUE (),
        MAX ( Table1[SLICER1] ) - MAX ( Table2[SLICER2] ),
        0
    )

[stretcharm]

take a look at selectedvalue and hasonevalue dax functions

there are several videos showing how this works e.g.

https://www.youtube.com/watch?v=FI1_N-imBxI

[ecmsev]

Thanks a lot for your answer,

¿Is it possible to create two measures with ISFILTERED()*1 for each slicer and after use both in the IF function?

IF(Measure1+Measure2)>=2;"0";column1-column2)