Forum Discussion
How To show average values in matrix visual
Hey team little help here as you can see ,
I have a matrix visualization here
that have area - row wise and controls - column wise
i need to find the average of these values,
also i have provided a measure as my values in here
need average both in column and row wise!!!
5 Replies
HI Anonymous ,
I am not sure on when you say you want to find average of values, what you are looking for?
Is the average of the percentage measure that you are displaying in the matrix? At what level you want the average?
Can you share you measure please?
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi Anonymous ,
As asked in my previous response, can you share the measure that you have writeen for these percentages? 🙂
Anonymous First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
