Slicer selected text. Calculate and get total count from Category in Matrix

[Anonymous]

Hello All!

Have a problem I can not solve. I used the report below for help, but I will not go all the way.

------------------------------------------------
Description:

Linked report gives me the sum of entries for the selected category. As well as the sum of the same row results.
If I choose Ticket1 in slicer as an example. I get data from column "Service" 365. In a matrix. I can see that there are 2 successful and a total of 4 for "Service" 365.

How do I find out what the last 2 results are, and get them in the same matrix?

Link:
https://community.powerbi.com/t5/Desktop/Calculate-distict-count-based-on-slicer-selection-in-Power-...

------------------------------------------------
What I'm trying to get :

Slicer select: Ticket1
Service: 365
Matrix
successful: 2
Failed: 1
successful (With issues): 1
Total: 4

What I´m getting:
Slicer select: Ticket1
Service: 365

Matrix
successful: 2
Total: 4

------------------------------------------------
Measure used and Data:

Data

Distinct Claim Numbers =
VAR custCat = DISTINCT('CM - Data'[Service])
RETURN
CALCULATE(COUNT('CM - Data'[Number]),ALL('CM - Data'[Text - Description]),custCat)

------------------------------------------------
Thanks in advance
" Swede who hopes to get better at power BI "

[amitchandak]

@Anonymous , I think you need an independent table with values of [Text - Description]

Tab1 = distinct('CM - Data'[Text - Description])

Then you need a measure  like

measure =

var _Tab = summarize(filter('CM - Data', 'CM - Data'[Text - Description] in allselcted(Tab1[Text - Description] ) ),'CM - Data'[Service]) 

retturn

countrows(filter('CM - Data' , 'CM - Data'[Service] in _Tab  ) )

refer, if needed

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE