Calculate the sum of average per category

[Anonymous]

I create the meausre for average per category in each project(x-axis is the project name), is there a way I can create the line total value for the sum of the average of each category? 

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?

If not, please let me know.

Best Regards

Maggie

[VasTg · Accepted solution]

@Anonymous 

You should look into clustered bar graph with dual y axis and add total measure as line.

Refer to these posts.

https://community.powerbi.com/t5/Desktop/Show-Total-in-Stacked-Column-Chart-with-legend/td-p/252180

https://www.youtube.com/watch?v=TV6YRmLYd9s

If it helps, mark it as a solution
Kudos are nice too

[Greg_Deckler]

Generally you do things like that with SUMX but hard to tell what you are going for exactly. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490