cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mega79
Helper I
Helper I

Sum of Average in Matrix visualization

Hi all, I'm trying to have the last line as a total of all average data shown in table. Basically all data shown by day is an average per day of a whole year. But when I use the Matrix visualization I cannot see the total but only the average of all SKUs... when I actually want the total of all SKUs.

 

Can anyone help?

Thanks.

 

Table.JPGTable 2.JPG

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@Mega79

 

You are missing a ) after Values(Sheet1[SKU]   

 

Regards

 




Lima - Peru

View solution in original post

4 REPLIES 4
Vvelarde
Community Champion
Community Champion

@Mega79

 

Hi, you need to create a measure:

 

AverageVolumen = AVERAGE(Table1[Volumen])

 

And another :

 

MeasuretoUse =
IF (
    HASONEVALUE ( Table1[SKU] );
    [AverageVolumen];
    SUMX ( VALUES ( Table1[SKU] ); [AverageVolumen] )
)

 

Img.png

Regards

 

Victor




Lima - Peru

Thanks for your response velarde. But it's giving me an error in the formula (see below)

 

Capture.JPG

Vvelarde
Community Champion
Community Champion

@Mega79

 

You are missing a ) after Values(Sheet1[SKU]   

 

Regards

 




Lima - Peru

View solution in original post

Thanks a lot for your help!!

It worked perfectly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.