Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I would really appreciate your help with the following.
I have some figures as in the following excel example.
Instead of showing the total as a simple average i want to show it as a weighted sum of the sales per FTE as illustrated in the formula. That is, I want to make more weight Group F than A since the sales number is larger thus more stable
Thanks in advance,
Kim
Solved! Go to Solution.
Hi @kimrhansen,
In Power BI Desktop, create the following measures in your table.
WeightedSum = SUMX(Table1,Table1[Sales]*Table1[Sales per FTE])
SumSales = SUM(Table1[Sales])
target = [WeightedSum]/[SumSales]
Thanks,
Lydia Zhang
Hi @kimrhansen,
In Power BI Desktop, create the following measures in your table.
WeightedSum = SUMX(Table1,Table1[Sales]*Table1[Sales per FTE])
SumSales = SUM(Table1[Sales])
target = [WeightedSum]/[SumSales]
Thanks,
Lydia Zhang
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |