Distinct duplication in cards

[prajaktakeni11]

Hello , I am showing dupliaction of subtype data in tabular version (Subtypetotal = countrows(Table)and filtering >1 )
I want to to show total number of type in cards as 4 (I have tried using distinct count but it is not giving me correct value), as per my data , but unable to get it can someone help Thank you in advance !!

[v-zhouwen-msft]

Hi @prajaktakeni11 ,

Table data are as follows:

Please follow these steps:
1. Use the following DAX expression to create a measure named 'TotalNumberOfType'

TotalNumberOfType = COUNTROWS(VALUES(Tabelle1[Type]))

2.Use the following DAX expression to create a measure named 'TotalNumberOfSub-Type'

TotalNumberOfSub-Type = COUNTROWS(VALUES(Tabelle1[Subtype]))

3. Final output

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[prajaktakeni11]

@v-zhouwen-msft  Thank you for your reply , but this is counts of duplications and it is not working for me it i sstill giving me Total Amount not distinct values