Average line in Analytics pane not working

[Anonymous]

Dear Power BI community,

I'm facing an issue I've spend some time researching but can't figure out so I thought I'd post it here. 

We use Power BI with a live connection to a multidimensional SSAS cube. For some measures, the average line from the Analytics pane always returns a 0 line. Even though there are clearly above 0 values, and all other line from the Analytics pane, such as min, max, median and percentile are working as expected. We face this issue in bothe Desktop and Power BI Online. 

See below example. On the left the measure for which the average line (blue) is incorrectly showing 0, while the median line (orange) works as expected. On the right another measure for which the average line (blue) works as expected. 

Has anyone seen this issue before, or knows where to search for a solution? Thanks in advance.

[RekhaJV]

Where to find this option in Version: 2.124.1554.0 64-bit (December 2023)???

[amitchandak]

@Anonymous , Can you check the average of the column used by creating measure on a card

average(Table[Value])

[Anonymous]

Hi @amitchandak 

Thanks for your fast reply. Because we use a live connection, I cannot add custom measures in my Power BI model. What I could do what create a query on the database on which the measures are created. The measures in my example are directly refering to a column in a table, so are not calculations in the SSAS cube.

I've made a query calculating the average for the measure which is not working. It results in 37, whereas the year totals are around 250 million. This average is calculated on a day level, whereas I need it in the report as a year level. But it does show that the average is clearly not 0. In my above screenshot I did not include the value of the average line. When I do that it shows 0.0000 which is clearly wrong. See below screenshot:

I've calculated the query as well for the measure which is working. In my query it gives the result on a date level, but in the report the average is correctly shown on a year level. I cannot see what the difference is between the measures.