Sum of Average in Matrix visualization

[Mega79]

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.

[Vvelarde]

@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] )
)

Regards

Victor

[Mega79]

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

[Vvelarde · Accepted solution]

@Mega79

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

Regards

[Mega79]

Thanks a lot for your help!!

It worked perfectly.