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...
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] ) )
)
WolfBiber's avatar
WolfBiber
Microsoft Employee
8 years ago
Just Click in Your visualisation and right click on values field and choose avg