Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
84 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |