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 ...
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.

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi   v-xjiin-msft 

    Boththe solutions Worked for me, Thanks a lot.

     

    Regards,