Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Total column in graphics

Hello everyone!!   I have data from diferent groups, lets say: Group 1, 2, 3, 4.... If I made a table in visuales it gives me back the "total" or "average" of all the groups. Is it possible to add ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ,

     

    Take "total " for example, you can create a measure such as below:

     

    Measure = SUMX(ALL('Table'),'Table'[Consumption])

     

     Then put the measure in the "value " field of a clustered column chart,and you will see:

     

    The same with "average",here is a sample .pbix file you can refer to.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Try like

Calculate(Average(table[Value]),all(Table))

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Hello! Thank you but is not what i need. I want to add that average with the other groups in a column chart, is that possible?
    • v-kelly-msft's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous ,

       

      Take "total " for example, you can create a measure such as below:

       

      Measure = SUMX(ALL('Table'),'Table'[Consumption])

       

       Then put the measure in the "value " field of a clustered column chart,and you will see:

       

      The same with "average",here is a sample .pbix file you can refer to.

       

      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!