Forum Discussion

Shelley's avatar
Shelley
Icon for Post Prodigy rankPost Prodigy
8 years ago

How to Total on a Subset, Ignoring One Slicer

I'm trying to count a subset of data, while ignoring only one slicer, but I can't seem to get it. I have a Service Ticket table and want to count the number of tickets for the Responsible Group (TSNA...
Need Help
Gracie's avatar
Gracie
Icon for Helper II rankHelper II
8 years ago

Try this:

 

var Total Service Tickets TSNA =
CALCULATE(DISTINCTCOUNT(ServiceTicket[Transaction Number]), [Responsible Group] = "TSNA")

 

return CALCULATE(Total Service Tickets TSNA, ALLEXCEPT(ServiceTickket, [Responsible Group]))