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.
Hi,
I have an urgent issue I hope someone can solve.
I have 4 tables in a tabular model that are related; Customer, Product, Sales Forecast, Sales Order Line.
All link with either Customer, product or a combination of both.
I have a calculation that is IF(SUM(Sales Order Line Qty - Sales Forecast Qty)<=0,0,SUM(Sales Order Line Qty - Sales Forecast Qty)) this is at product level.
I want to sum the result of this calculation to customer level, as the customer may have one or more products.
Just summing at Customer level gives the wrong amount. This is because a customer may have been supplied a product that has not been forecast and vice versa.
So in summary, sum the result from the lower level sum.
I think I am overthinking this lol.
Regards
Mark
I solved the problem by creating a sumx over a cross joi.
Asking Questions on Power BI Forum - https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |