Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Slicer with multiple criteria values

Hi!   If I have a table like this: How is it possible to create slicer (or preferably ChicletSlicer) in which I could choose from two alternatives. Alternative one would show values from bot...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    Add a separate table for Slicer and use measure below.

    Measure =
IF (
    SELECTEDVALUE ( Table2[Column1] ) = "Category 1",
    CALCULATE ( SUM ( Table1[value] ), Table1[category] = 1 ),
    SUM ( Table1[value] )
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous,

 

Add a separate table for Slicer and use measure below.

Measure =
IF (
    SELECTEDVALUE ( Table2[Column1] ) = "Category 1",
    CALCULATE ( SUM ( Table1[value] ), Table1[category] = 1 ),
    SUM ( Table1[value] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks, Sam!

     

    I guess that would do it!

     

    I ended up doing a separate table like this and using name field in the slicer: