Forum Discussion

gray169's avatar
gray169
Frequent Visitor
3 years ago

Row Sub Total Question

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 🙂

 

Need Help

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    3 years ago

    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.