Forum Discussion

prajaktakeni11's avatar
prajaktakeni11
Icon for Helper I rankHelper I
2 years ago

Distinct duplication in cards

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 !!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      prajaktakeni11
      Icon for Helper I rankHelper I
      2 years ago

      Anonymous  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