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.
Can someone tell me what on earth is PowerBI's logic here? And how can I get it to show the average of all the numbers in the row?
In your matrix visual, it looks like the Total column is displaying the sum of the values in each row, while the Grand Total row is displaying the sum of the values in each column.
To display the average of all the numbers in each row, you can add a new measure to your data model that calculates the average for each row, and then use that measure in your matrix visual.
Here's an example of how to create the measure:
Once you have created the measure, you can add it to your matrix visual by dragging it from the "Fields" pane to the "Values" area of the visual. You should then see the average value for each row in the Total column of the matrix visual.
Thanks, that does make sense but in this situation, this would create an additional column beside each existing column which is not what I want. I want one summary column.
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 |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
80 | |
67 |