Forum Discussion
aslan
Helper I
Helper IGrand Total is not correct
Grand total must be 73,85 but it shows 73,78. Why is it? Can you please help?
MarcelBeug
Community Champion
Community ChampionLet me get this straight: 73,78% is the correct answer, but you are seeking for an incorrect answer.
That's why your measure results in 73.78%.
In order to get your incorrect answer of 73.85%, you need a calculated column with the percentages and then take the average of those percentages (excluding zeroes),
I know how to do the manipulation in Power Query to get the answer you are looking for, but not in DAX.
My advice would be to accept 73.78% as the correct answer.
aslanHelper I
Helper IHi MarcelBeug 73.78% is correct but client want to see 73.85% by calculating average. But couldn't create calculated column and because of that can't calculate average.