Grand Total percentage of status

[aherabit]

Hi Folks,

Would you suggest a way to display the grand total status based on 'status' categories?

Currently, the pie-chart is displaying inidividual status.

Thank you

[Ritaf1983 · Accepted solution]

Hi @aherabit 

If I understand you correctly and the structure of the bottom table is the structure of your data table.
Then there are 2 options to show the total by categories.

1. To unpivot your table with PQ ( most recommended)

Result table :

Graph by status :

Another option is to calculate the total with Dax:

Total = SUMX('Table (2)','Table (2)'[test 1]+'Table (2)'[test 2]+'Table (2)'[test 3]+'Table (2)'[test 4]+'Table (2)'[test 5])

And put this measure on your chart

Link to the sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[aherabit]

Worked.   Thank you very much.

[Ritaf1983]

Glad to help☺️