Forum Discussion
tamdji
7 years agoNew Member
Analytics pane measures
Hi there, Could anyone explain to me how the Analytics pane measures (mean, percentile ...etc) are calculated ? When I do calculate the mean or percentile via excel or DAX functions I do not get ...
- 7 years ago
Hi there,
Thanks a lot I think I figured out what the problem was. For instance, lets say in column A you have cities name and column B the city population number. What happens is that when in column A all city names are different then what the analytics pane calcultes as a mean is correct, but as soon as you have a city name more than once in column A, PBI will sum the two corresponding records in column B and consider the sum as one element (which is not what I want).
xoxo
v-cherch-msft
7 years agoMicrosoft Employee
Hi tamdji
Based on my test, show a simplified sample as below. You may refer to the measure in picture.
Regards,
Cherie