Forum Discussion

VikasMattela's avatar
VikasMattela
Frequent Visitor
3 years ago

SUM while selecting multiple values in Slicer (Measure)

Hi,

 

I have created a slicer with multiple values, when I select 2 or more slicer value. I need some based on those 2 values only.

someone could please suggest me the better way to do it.

 

I tried with SELECTEDVALUE,but when I select 2 or more slicer values its not working.

 

 

 

1 Reply

  • MohammadLoran25's avatar
    MohammadLoran25
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi VikasMattela ,

    You need to use ALLSELECTED function:

     

    CALCULATE(

    [YourMEasureName],

    ALLSELECTED('YourTableName')

     

    )

     

    If this answer solves your problem, accept it as a solution so others would find what they need easier.

    Regard,

    Loran