Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
adithyanv
Employee
Employee

Need to display average instead of totals in a matrix

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 :

adithyanv_0-1679640663432.png

Data given in rows,columns and values :

adithyanv_1-1679640697776.png

 

 My expected outcome is :

adithyanv_2-1679642209862.png

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

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

 

 

1 ACCEPTED SOLUTION

@adithyanv 
Then use

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

View solution in original post

6 REPLIES 6
tamerj1
Super User
Super User

Hi @adithyanv 
Please try this measure in the values of the matrix

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

Hey thanks for the quick reply,

now the row wise average are correct

but column wise is wrong

 

adithyanv_0-1679646828485.png

 

@adithyanv 

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

coming from same table

@adithyanv 
Then use

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

its working now thank you

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors