The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
63 | |
32 | |
21 | |
16 | |
15 |
User | Count |
---|---|
115 | |
33 | |
30 | |
24 | |
21 |