Forum Discussion

Zaky's avatar
Zaky
Icon for Helper IV rankHelper IV
6 years ago
Solved

Countrows Measure

Hi, I cant figure it out on how can I countrows for total SRID table exactly to count 18 tickets although it has duplicate tickets number?   Thanks.   SRID REQ000002749171 REQ0000027491...
Need Help
  • FrankAT's avatar
    FrankAT
    6 years ago

    Hi Zaky 

    are you looking for the following solution?

     

     

    Regards FrankAT

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Zaky you can add a measure to calculate distinct values

 

Distinct Value = DISTINCTCOUNT ( Table[Column] )

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Zaky's avatar
Zaky
Icon for Helper IV rankHelper IV
6 years ago

parry2k

 

It's still count 16 tickets ignoring 2 tickets which are duplicate tickets. . It supposed to count 18 tickets.

 

Thanks in advance for your help.