Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sure19
Helper II
Helper II

Average shows wrong totals

Dear Sir, I have done a report which shows the average of the rows and average of the column, the rows average shows correct figure while the column average shows wrong figure

2 REPLIES 2
v-haibl-msft
Employee
Employee

@sure19

 

There may be something wrong with your average measure. You need to post some sample data and your DAX formula to figure out the problem.

 

Best Regards,

Herbert

Hello guys,

 

I have a similar problem with my total column average. I was trying to insert a screenshot from Snipping tool, but it doesn't seem to be working...

 

I have the following values of Data Type: Decimal Number; Format: Percentage; Default Summarization: Average;

 

Count    Value   Week

1            43%     10/04/2015

1            43%     11/01/2015

1            43%     11/15/2015

1            43%     11/22/2015

1            43%     12/06/2015

2            40%     12/13/2015

 

I expect the total average for these weeks (i.e. 2015 Q4) to be 42.14%. However, my Power BI matrix table shows 40%.

 

How can I fix this? There are no 0 values in the datasource (seemed to be a problem for other people with similar problem). This is also not a result of incomplete data for Q4 because in that case the average shown by Power BI would be 19.62%. Can it be related to the fact that the Week is coming from a separate Date table I created myself rather than from the main datasource? 

 

Your help and insigts are much appreciated!

 

Regards,

Gabriele

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.