Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!
Solved! Go to Solution.
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
Wow, that was fast and worked perfectly! Thank you so much!!!
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
9 |
User | Count |
---|---|
27 | |
23 | |
12 | |
11 | |
10 |