Is this correct?

[Johan-MTM]

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 

[aditya0125]

Number of Borrowers = calculate(DISTINCTCOUNT('public borrower'[id]), filter(public borrower,'public borrower'[borrower_deleted]=FALSE())

[ryan_mayu · Accepted solution]

@Johan-MTM 

you are using distinctcount which will not count duplicates. 

it's called DAX function.

DAX function reference - DAX | Microsoft Learn

[Johan-MTM]

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]

@Johan-MTM ,

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

Thanks,

Arul 

[Arul]

@Johan-MTM ,

Do you need distinct id or total count of borrower_deleted?

Thanks,

Arul