How To show average values in matrix visual

[Anonymous]

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!!!

[Greg_Deckler]

@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

[Pragati11]

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

[Anonymous]

in the value field of the matrix  , i have been using a measure that displays percentages

I need to find the averages of these percentages row wise and column wise

[Pragati11]

Hi @Anonymous ,

As asked in my previous response, can you share the measure that you have writeen for these percentages? 🙂

[Anonymous]

 % = SWITCH(TRUE(),DIVIDE([EC],[TC])=0,0,[EC]>=1,DIVIDE([EC],[TC]))