Change table visualization total

[marcelpinheiro]

Hello

I have a table visualization  and i need to change the summarize of certain column to average instead of sum. How can i do this?

I need to change the second column summarize to average total

[v-chuncz-msft · Accepted solution]

@marcelpinheiro,

You may add a measure as shown below.

Measure =
AVERAGEX (
    SUMMARIZE ( Table1, Table1[Column1] ),
    CALCULATE ( SUM ( Table1[Column2] ) )
)

[WolfBiber]

Just Click in Your visualisation and right click on values field and choose avg