Need Help with slicers Formula

[Anonymous]

Hi,

Need help with a tricky senario for dynamic values for slicers 

I have 3 slicers Slicer A,Slicer B, Slicer C

Below are the scenarios

Scenario 1:When I choose anything from Slicer A or Slicer B , the card has to display 'X' value

Scenario 2:When I choose anything from Slicer C , the card has to display 'Y' value

Scenario 3:When I choose anything from Slicer A or Slicer B and Slicer C  (or) vice versa, the card has to display 'Z' value

below is the formula that I tried, it works for scenario 1 and 2 , but for scenario 3 it gives the value of X instead of Z

Measure  = IF((ISFILTERED(Slicer A) || (ISFILTERED(Slicer B)),100,if(ISFILTERED(Slicer C),200,IF((ISFILTERED(Slicer A) || ISFILTERED(Slicer B)),&&(ISFILTERED(Slicer C)),300,1)))

Thanks,

[Greg_Deckler · Accepted solution]

Probably something like:

Measure = IF((ISFILTERED(Slicer A) || (ISFILTERED(Slicer B)) && NOT((ISFILTERED(Slicer C))),100,if(ISFILTERED(Slicer C),200,IF((ISFILTERED(Slicer A) || ISFILTERED(Slicer B)),&&(ISFILTERED(Slicer C)),300,1)))

[v-xjiin-msft · Accepted solution]

Hi @Anonymous,

I think it might be:

Measure =
IF (
    ( ISFILTERED ( SlicerA ) || ISFILTERED ( SlicerB ) )
        && NOT ( ISFILTERED ( SlicerC ) ),
    100,
    IF (
        ISFILTERED ( SlicerC ) && NOT ( ISFILTERED ( SlicerA ) )
            && NOT ( ISFILTERED ( SlicerB ) ),
        200,
        IF (
            ( ISFILTERED ( SlicerA ) || ISFILTERED ( SlicerB ) )
                && ISFILTERED ( SlicerC ),
            300,
            1
        )
    )
)

Thanks,
Xi Jin.

[Anonymous]

Hi smoupre  v-xjiin-msft 

Boththe solutions Worked for me, Thanks a lot.

Regards,

[Greg_Deckler · Accepted solution]

Probably something like:

Measure = IF((ISFILTERED(Slicer A) || (ISFILTERED(Slicer B)) && NOT((ISFILTERED(Slicer C))),100,if(ISFILTERED(Slicer C),200,IF((ISFILTERED(Slicer A) || ISFILTERED(Slicer B)),&&(ISFILTERED(Slicer C)),300,1)))