Forum Discussion

Johan-MTM's avatar
Johan-MTM
Icon for Helper III rankHelper III
3 years ago
Solved

Is this correct?

Hi!   I want to count "id" from the table "public borrower" but only those that are borrower_deleted=FALSE.      Number of Borrowers = calculate(DISTINCTCOUNT('public borrower'[id]),'publ...
Need Help
  • Johan-MTM's avatar
    Johan-MTM
    Icon for Helper III rankHelper III
    3 years ago

    Thanks Arul 
    There should not be any duplicates so then it should be ok. And I wrote the function corret so only ID with borrowe_deleted=FLASE will be counted right?

     

    • Arul's avatar
      Arul
      Icon for Super User rankSuper User
      3 years ago

      Johan-MTM ,

      Yes, It should count the correct number of id's and should be give you the correct numbers.

      Thanks,

      Arul