Forum Discussion
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...
you are using distinctcount which will not count duplicates.
it's called DAX function.
DAX function reference - DAX | Microsoft Learn
Number of Borrowers = calculate(DISTINCTCOUNT('public borrower'[id]), filter(public borrower,'public borrower'[borrower_deleted]=FALSE())