Row Sub Total Question

[gray169]

Hi,

I have a simple Matrix, showing what Service Desk Tickets "Met" or "Missed" their SLA target (which is 95%)

My question how can i get the total of both "Met" and "Missed" so i can create % Per Month Result

Getting the Grand Total was easy (but totally different in latest build, but save that for another day 🙂

[v-xiaotang]

Hi @gray169 

Thanks for reaching out to us.

>>  how can i get the total of both "Met" and "Missed"

Usually we filter on the table and then sum, for example, calculate(sum('table'[count]),filter(all('table'),'table'[Priority] in {"Met","Missed"})

Best Regards,

Community Support Team _Tang

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