topic Re: SUM while selecting multiple values in Slicer (Measure) in DAX Commands and Tips

SUM while selecting multiple values in Slicer (Measure)

VikasMattela — Sun, 26 Mar 2023 17:16:14 GMT

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.

MohammadLoran25 — Sun, 26 Mar 2023 18:58:00 GMT

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