cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## SELECTEDVALUE - Sum With Multiple Selections

Hello Everyone,

I have a question as to how I can apply a multiple criteria selection in a Slicer and sum up the total? Unfortunately this is not as simple as it sounds. I need to list the Customer and their Total Sales next to each other in a Table, as well as the Selected Sales next to Total Sales.

Even if Selected Sales is \$0, I need to display that row because the Customer has other sales. This is what I have for the DAX measure for Selected Sales:

``````Selected Product Sales =
VAR a = SELECTEDVALUE(MySales[Product],0)
VAR b =
CALCULATE(
SUM(MySales[Amount]),
FILTER(MySales, MySales[Product] = a)
)
RETURN b+0``````

The slicer is set to select the Product from the Product Table, which is not related to the MySales table. This all works perfectly when selecting a single Product. But when I select multiple products, the resulting Sum of Selected Sales goes to \$0.

How can I change this to sum up the total sales of all Products selected in the slicer? SELECTEDVALUE doesn't seem to be the appropriate option...

Thanks for any help!

1 ACCEPTED SOLUTION
Super User

To get 1 or more selected values you can use VALUES, e.g.

``````Selected Product Sales =
CALCULATE (
SUM ( MySales[Amount] ),
TREATAS ( VALUES ( 'Product'[Product] ), MySales[Product] )
) + 0
``````
2 REPLIES 2
Frequent Visitor

Wow, that was fast and worked perfectly! Thank you so much!!!

Super User

To get 1 or more selected values you can use VALUES, e.g.

``````Selected Product Sales =
CALCULATE (
SUM ( MySales[Amount] ),
TREATAS ( VALUES ( 'Product'[Product] ), MySales[Product] )
) + 0
``````

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors