Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |