Total column in graphics

[Anonymous]

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 this "total" or "average" in a column chart??? It would be perfect if it can appear as a sepparate column in the graphic with the other columns of Group 1, 2, 3.... to compare them visually. Thanks in advance!!

[amitchandak]

Try like

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

[Anonymous]

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 · Accepted solution]

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!