Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
ryanjparks
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
johnt75
Super User
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

View solution in original post

2 REPLIES 2
ryanjparks
Frequent Visitor

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

johnt75
Super User
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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.