Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |