Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Need Help with slicers Formula

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,

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    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's avatar
    v-xjiin-msft
    8 years ago

    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.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    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's avatar
    v-xjiin-msft
    Solution Sage
    8 years ago

    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.