Total is coming less

Question

Hi,&nbsp;i have the following data where serviceID is from Table Service and Ticket with ServiceID Mapping in another table.&nbsp;Ticket&nbsp; &nbsp; &nbsp;StatusT1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PT2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PT3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RT4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RT5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P&nbsp;ServiceID&nbsp; &nbsp;&nbsp;S1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;S1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;S1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;S2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;S2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;when i do summary by services count in matrix i get like this&nbsp;Status&nbsp; &nbsp; CountOfTicket-------&nbsp; &nbsp; &nbsp;----------------P&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3R&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2---------------------------total&nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp;but i want to get result as 5 instead of 2.&nbsp;

v-juanli-msft · Accepted Answer

Hi&nbsp;

I don’t understand clearly what do you mean by saying “do summary by services count” and how Ticket with ServiceID Mapping.
Based on my understanding, with the dataset below, I create a measure and get the total a result as 5 in a Matrix.
&nbsp;

measure =
CALCULATE ( COUNT ( Sheet1[Ticket ] ), ALLEXCEPT ( Sheet1, Sheet1[Status] ) )

If my understanding is not right, please point out the correct way for me at your convenience.

&nbsp;
&nbsp;
Best Regards
Maggie

Forum Discussion

Total is coming less

1 Reply

Related content

Total is coming blank for a measure

Total should come first column

Cumulative Total

Total of a calculated measure is not coming correct

The total is coming incorrect.