Forum Discussion
Divergent values in the average calculation
Hi lcfaria
The 2.07% is the correct one. it represents the SUM of [Bonus] = 62 divided by the DISTINCTCOUNT of the number of managers that = 30 of the Unit A.
Hi aj1973,
I already realized where the problem was, although I have 30 distinct managers, it should only consider those that have a target > 0, in the case of the example, 22 managers.
62 / 22 = 2.82%
Although I had a filter applied to the visual only for target > 0:
When I removed the managers from the table and kept only the unit, the measure stopped considering the 22 managers and started to consider all 30 (I still don't understand why this failed to consider the filter applied in the image above).
I made a simple change in the measure DAX and it solved the problem:
Your answer helped me find the problem, thank you very much!