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
PowerBiNoobie1's avatar
PowerBiNoobie1
Helper I
5 years ago

hi v-zhenbw-msft 

 

OK so I have a card visual with the P50 Latency field in it, its a CQD measure. I am simply trying to change the summarisation to be average as I want to see the average latency for all calls made between two network points. I have page level filters creating the overall filter for the report which tells PowerBI to only filter for traffic between two specific network points and to report latency, jitter and packet loss for each call. I need PowerBI to return the average value of jitter, latency and packet loss for all calls that are returned by the page filter. I realise I am probably not doing this correctly!? 

 

I cant create a query or manipulate the source dataset in PowerBI as nothing works at all after I do that. This has been reported as a bug by MS.

 

Thanks

 

Thanks for your reply 

PowerBiNoobie1's avatar
PowerBiNoobie1
Helper I
5 years ago

v-zhenbw-msft 

I have since tried creating a new measure as below:

 

AverageLatency = Average(Query1[P50 Latency])
 
I tried adding that to the card visual and I get the same error. SQLDumper runs and then data cannot be displayed. The source data is a decimal value. I assume this is how I should be getting the average of the P50 Latency.
 
Thanks!