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]),'public borrower'[borrower_deleted]=FALSE())Thanks Ps Also - the language used here is called Dax or?/johan

Johan-MTM you are using distinctcount which will not count duplicates. it's called DAX function. DAX function reference - DAX | Microsoft Learn

Is this correct? | Microsoft Fabric Community

Arul
Super User
3 years ago
Johan-MTM ,

Do you need distinct id or total count of borrower_deleted?

Thanks,

Arul
Anonymous
Not applicable
3 years ago
Number of Borrowers = calculate(DISTINCTCOUNT('public borrower'[id]), filter(public borrower,'public borrower'[borrower_deleted]=FALSE())
ryan_mayu
Super User
3 years ago
Johan-MTM

you are using distinctcount which will not count duplicates.

it's called DAX function.

DAX function reference - DAX | Microsoft Learn
- Johan-MTM
  Helper 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
    Super 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