March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello
I am wanting to generate a measure derived from another, based on Total Sales (previous measure) but now another, associated with products with Profit Margin (another measure) greater than 35%, and where sales do not correspond to products with this condition, which places $ 0. What dictates my understanding is that it should be Measure = CALCULATE([Total Sales], FILTER(Measures,Measures[Profit Margin]>=0.35))), however, under this formula Total Sales are being returned without being affected by the filter. Could you help me with the error or guide me with a suitable solution? The idea with this measure is to generate a column chart where total sales are displayed, how much corresponds to the number of products with the highest margin.
Thank you for the support and guidance.
You need to create a summary table which can be used as a filter, but you first need to determine at what granularity you want to measure the profit margin. If it is over the entire life of the product you could do something like
Sales High Margin =
CALCULATE (
[Total Sales],
FILTER ( VALUES ( 'Sales'[Product ID] ), [Profit Margin] >= 0.35 )
)
but if you wanted to calculate profit margin at the product and year grain it would be something like
Sales High Margin =
CALCULATE (
[Total Sales],
FILTER (
SUMMARIZE ( 'Sales', 'Sales'[Product ID], 'Date'[Year] ),
[Profit Margin] >= 0.35
)
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |