Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |