The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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