Forum Discussion

PowerBiNoobie1's avatar
PowerBiNoobie1
Helper I
5 years ago

PowerBI Errors pfoledbreader.cpp

Hi All   Seems like I am having fun with PowerBI. Seems like every day I have a new problem\error right now 😞   So my latest issue is when I change a measure to be a different value to SUM, say ...
Need Help
v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
5 years ago

Hi PowerBiNoobie1 ,

 

Have you tried not applying the AVERAGE function, but dividing the SUM function by the COUNT or DISTINCTCOUNT function?

The formula like this,

 

AverageLatency = DIVIDE(SUM(Query1[P50 Latency]), DISTINCTCOUNT(calls))

 

And have you tried to submit a support ticket?

 

Best regards,

 

Community Support Team _ zhenbw

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