Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |