Forum Discussion

marcelpinheiro's avatar
marcelpinheiro
Regular Visitor
8 years ago
Solved

Change table visualization total

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

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    marcelpinheiro,

     

    You may add a measure as shown below.

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

2 Replies

  • WolfBiber's avatar
    WolfBiber
    Microsoft Employee
    8 years ago
    Just Click in Your visualisation and right click on values field and choose avg
  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    marcelpinheiro,

     

    You may add a measure as shown below.

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