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.
How to calculate the minimum of a measure?
I have this Field Parameter with meaures:
NetSales = SUM('Table'[SalesValue])
SalesQty = SUM('Table'[Quantity])
Table is like:
Customer ID | Quantity | SalesValue
I want the minimum value of Quantity and Sales value per customer id.
So, using the NetSales in a slicer (single selection), the following expression:
Thank you for your help.
But, how about when the user changes the slicer value from Net Sales to Sales Quantity?
What you mena under Slicer Values Change?
MinSalesQty = CALCULATE(MIn('Sales'[Quantity]), ALLEXCEPT(Sales,Sales[Customer ID]))
Same for Qnt
MinNetSales = CALCULATE(MIN(Sales[SalesValue]),ALLEXCEPT(Sales,Sales[Customer ID]))
See attached file:
https://drive.google.com/file/d/1C-ssh8zFbl2PkfUvRTiiP0R4jLjlGVEq/view?usp=share_link
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |