Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Is there any measure that i can use to calculate the order total when it contains multiple products.
I know that i can use visuals which will do this automatically but i need also a measure to be able to filter orders based on ammounts.
What i need is a measure that will return the total of an order ( AAA= 30 and BBB = 200) so i can then be able to filter these orders based on a given value (more than 50, more than 100, between 10 and 100 etc for which i will use a slicer).
Order | Product | Price |
AAA | nnn | 10 |
AAA | mmm | 20 |
BBB | xxx | 100 |
BBB | yyy | 100 |
Solved! Go to Solution.
this should work:
Measure
#Price = CALCULATE(sum(Sheet1[Price]),ALLEXCEPT(Sheet1,Sheet1[Order]))
Column - which you can use as a slicer
*Price = [#Price]
Thank you for your help, it worked as expected for given example.
However, looking to the data, there are more scenarios that i did not forsee when using the column for slicer (which for me is much more useful).
Is there a way to have a column to return me the Expected result? I do not have other fields to differentiate.
Order | Product | Price | Result | Expected result |
AAA | mmm | 10 | 40 | 40 |
AAA | mmm | 10 | 40 | (blank) |
AAA | nnn | 20 | 40 | (blank) |
BBB | xxx | 100 | 200 | 200 |
BBB | yyy | 100 | 200 | (blank) |
See if this will work for you:
this should work:
Measure
#Price = CALCULATE(sum(Sheet1[Price]),ALLEXCEPT(Sheet1,Sheet1[Order]))
Column - which you can use as a slicer
*Price = [#Price]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
76 | |
58 | |
47 | |
17 | |
12 |