Count Based on Distinct Count of another column

[kimchour]

Hello everyone, i want to count how many user that use only 1 Tcode? i want to display a card for example:

Used 1 Tcode
15 Users

currently i already use distince count the Tcode in the first table. for second table, that same user use the same Tcode everyday, but user use only 1 same tcode.
please take a look at the screenshot. thank you for your help so much.

first tablesecond table

[Jihwan_Kim · Accepted solution]

Hi, I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Used Tcodes: = 
COUNTROWS(DISTINCT(Data[Tcode]))

Used only one Tcode: =
VAR _t =
    FILTER ( VALUES ( User[User] ), [Used Tcodes:] = 1 )
RETURN
    COUNTROWS ( _t )

[kimchour]

THANK YOU SO MUCH. this is exactly what i am looking for. 😍🙏