Forum Discussion

AgustinBrocardo's avatar
AgustinBrocardo
Frequent Visitor
4 years ago

average calculation problem

Hi! I´m having a problem but i cannot find the cause.   I make a survey to my customers for them to rate my service from 1 to 5 and some of them may not respond, as you can see in the capture. ...
v-cazheng-msft's avatar
v-cazheng-msft
Community Support
4 years ago

Hi AgustinBrocardo 

 

May I know is your issue resolved? If your issue still exists, could you please show us how you calculate the average in Power BI? Is there any Measure you create to get the Rating on mean?

 

Best Regards,

Community Support Team _ Caiyun

 

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

AgustinBrocardo's avatar
AgustinBrocardo
Frequent Visitor
4 years ago

hi v-cazheng-msft 

 

We tried solving the problem with my team too. The average is a simple calculation made by the visual by selecting "average" when showing values, there is no measure.

 

We couldn´t find the cause of the problem, we created a new report and started over. The second time i didn´t make any change to the data in power query and this time the average was calculated correctly. It seems the problem was in the query steps, which just was unpivoting some columns. 

 

I still don´t understand why unpivoting some columns could cause this problem but i worked around it.