Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Please see the sample data below. I have the first three columns in my source data but I need help with the weighted columns. I am trying to create three measures. One that will calculate a Weight (rev per customer/total rev ), Weighted GM (Weight * GM), and Weighted GM% ( GM / Rev). Also, would I be able to filter these in a chart and still have accurate numbers? I appreciate the assistance!
Solved! Go to Solution.
Hi,
Write these measures
Gross margin = sum(Data[GM[)
Revenue = sum(Data[Rev])
Revenue across all customers = calculate([Revenue],all(Data[Customers]))
Weight = divide([Revenue],[Revenue across all customers])
Weighted GM = SUMX(Values(Data[Customers]),[Weight]*[Gross margin])
Weighted GM % = divide([Weighted GM],[Revenue])
Hope this helps.
Thank you, this was very helpful!
Hi,
Write these measures
Gross margin = sum(Data[GM[)
Revenue = sum(Data[Rev])
Revenue across all customers = calculate([Revenue],all(Data[Customers]))
Weight = divide([Revenue],[Revenue across all customers])
Weighted GM = SUMX(Values(Data[Customers]),[Weight]*[Gross margin])
Weighted GM % = divide([Weighted GM],[Revenue])
Hope this helps.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |