topic Re: Need to display average instead of totals in a matrix in DAX Commands and Tips

Need to display average instead of totals in a matrix

Anonymous — Fri, 24 Mar 2023 07:18:05 GMT

Hi Team,

As you can see i have a matrix visualization here , Having Rows : Area , Columns : Controls , And Values : A measure

i need to find the average but the average is showing here as wrong as below picture :

Data given in rows,columns and values :

My expected outcome is :

Example for averages : ACA average is calculated as 0/1=0%

Brazil Average is calculated as 100+17/2=59%

tamerj1 — Fri, 24 Mar 2023 08:12:09 GMT

Hi Anonymous
Please try this measure in the values of the matrix

Exception HAndling % Average Total = AVERAGEX ( VALUES ( 'Table'[Control] ), [Exception HAndling %] )

Anonymous — Fri, 24 Mar 2023 08:34:24 GMT

Hey thanks for the quick reply,

now the row wise average are correct

but column wise is wrong

tamerj1 — Fri, 24 Mar 2023 08:37:51 GMT

Anonymous

Are area and Control from the same table? If different tables, would you please provide details about the relationships?

Anonymous — Fri, 24 Mar 2023 08:40:10 GMT

coming from same table

tamerj1 — Fri, 24 Mar 2023 08:41:02 GMT

Anonymous
Then use

Exception HAndling % Average Total = AVERAGEX ( SUMMARIZE ( 'Table', 'Table'[Area], 'Table'[Control] ), [Exception HAndling %] )

Anonymous — Fri, 24 Mar 2023 08:49:45 GMT

its working now thank you