Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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