How to show sub total as an average in matrix visualization?

[KBO]

Hi,

can anybody show me what I have to do If I want to show my sub total in a matrix visual as average? Is this possible in the matrix visual configuration or need I an measure or calculated column? 

Thanks for your help,

with best regards

Kathrin

[Hardik]

right click on the dersired column in the tools tab and select average

[KBO]

There is no average which I can choose - it looks like your picture :).

[Vvelarde · Accepted solution]

@KBO

Hi, you can follow this pattern:

ComisionTotal-WithAverageinTotal =
IF (
    HASONEVALUE ( Table1[Name] );
    [Comisión Total];
    AVERAGEX ( VALUES ( Table1[Name] ); [Comisión Total] )
)

Regards

Victor