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.
Hi,
I am trying to take average of row values rather than sum in matrix.
I have seen https://community.powerbi.com/t5/Desktop/Median-of-Row-Column-in-Matrix/m-p/58209#M23837 this
post which is totally what I intended to solve, but it changes row values as well.
I want to keep row values, and only change the total column sum to average in row based.
If anyone has an idea, I would be grateful.
Solved! Go to Solution.
Hi scherd,
Based on my understanding, you want to get the average total of your records and keep row values, right?
You can add a unique column to keep the values.(based on Michael_Shao’s point).
Below is the Sample:
1. Create a table.
2. Create the matrix visual.
As you said, the value has changed.
3. Add a unique column to fix the issue.(e.g. add an index column in Query Editor)
4. Add this column to matrix.
The issue has been fixed.
Regards,
Xiaoxin Sheng
Hey I figured out another way to do this. You can create a new measure and use DAX to create an AVERAGE of any column in your table. Then create a new matrix and include those average measures. Turn totals off in the general settings of your original table and position your new 1-row table directly below your other table. Include a text object to the left to label is at averages.
Hi scherd,
Based on my understanding, you want to get the average total of your records and keep row values, right?
You can add a unique column to keep the values.(based on Michael_Shao’s point).
Below is the Sample:
1. Create a table.
2. Create the matrix visual.
As you said, the value has changed.
3. Add a unique column to fix the issue.(e.g. add an index column in Query Editor)
4. Add this column to matrix.
The issue has been fixed.
Regards,
Xiaoxin Sheng
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |