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 all,
I need help to calculate Margin, when I have both sales and cost in the same column.
I tried with the following measure, but no values are showing when I put the measure into a visual.
If you get nothing from that margin calculated i's leading me to believe that something is wrong with that account filter.
Start by creating seperate measures for sales and cost and make sure that they are working.
If you're getting nothing there, try calculating with the specific account instead of the groups.
Let me know how it goes.
/ J
You were right, the specific account needed to be different.
Thanks for the input!
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |