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.
I have this problem giving me gray hair.
So I have customer no, sales, cost and cost of sales %.
The cost of sales % is correct for each customer no, but the total is wrong.
I would like it to be total sales divided with total cost, but instead it´s summarized.
Also the green visualizations is summarized, and choosing avarage or median also gives me the wrong result.
Hi, @Dhjlm
From your screenshot, we can't see how the 'cost of sales %' is calculated? So can you explain it?
If it's a measure, you may need to modify it by using sum(summarize()) function to make the total correct.
And it's better to share some sample data and your desired result. So we can help you soon.
Best Regards,
Community Support Team _ Janey
@Dhjlm , will measure like that help ?
divide(Sum(Table[Cost]), Sum(Table[Sales]) )
Sorry, that didn´t help
can you share your Dax ?
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |