Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi guys,
Any idea on why is the sum of the percentages in the Graph different from the sum of the Card?
5,20 + 8,20 + 7,95 + 7,00 + 7,45 + 6,16 + 4,69 = 46,65% at total or 46,65 / 7 = 6,66% on average.
But in the Card...
The average also not the same...
The DAX measure:
Solved! Go to Solution.
Hi, here's the DAX measure that solves the problem:
Hi, here's the DAX measure that solves the problem:
Can you share somedata ?
I've done the same calculation in a new file and the number were correct. So maybe the problem is inside my PBI. I've tried everything, from changing the measure, deleting all others visuals, removing page and report filters...
The grand total always results in a number different from the sum of the percentages.
What's confusing is that the measure isn't all that complicated, and for all the tests made, the numbers of headcount and the numbers of admissions and resigns results in the correct percentage for the month.
As always, these calculated results are a nightmare of every analyst that uses PBI.
Data Sample:
MonthNo | Month | Turnover | Admissions | Resigns | Headcount without absence | Headcount Beggining of the Month |
1 | January | 5,20% | 235 | 254 | 4695 | 4698 |
2 | February | 8,20% | 450 | 328 | 4776 | 4704 |
3 | March | 7,95% | 431 | 336 | 4847 | 4800 |
4 | April | 7,00% | 342 | 335 | 4826 | 4841 |
5 | May | 7,45% | 393 | 328 | 4871 | 4808 |
6 | June | 6,16% | 319 | 281 | 4887 | 4856 |
7 | July | 4,79% | 244 | 227 | 4916 | 4911 |
Hi,
Share the download link of the PBI file.
You can try the following measures.
Sum_Rotatividade =
SUMX ( ALLSELECTED ( table ), [Rotatividade Geral] )
Average_Rotatividade =
DIVIDE (
[Sum_Rotatividade],
CALCULATE ( DISTINCTCOUNT ( table[Month] ), ALLSELECTED ( table ) )
)
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
91 | |
84 | |
76 | |
64 |
User | Count |
---|---|
136 | |
113 | |
104 | |
98 | |
92 |