Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi!
I want to count "id" from the table "public borrower" but only those that are borrower_deleted=FALSE.
Solved! Go to Solution.
you are using distinctcount which will not count duplicates.
it's called DAX function.
DAX function reference - DAX | Microsoft Learn
Proud to be a Super User!
Number of Borrowers = calculate(DISTINCTCOUNT('public borrower'[id]), filter(public borrower,'public borrower'[borrower_deleted]=FALSE())
you are using distinctcount which will not count duplicates.
it's called DAX function.
DAX function reference - DAX | Microsoft Learn
Proud to be a Super User!
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?
Yes, It should count the correct number of id's and should be give you the correct numbers.
Thanks,
Arul
Do you need distinct id or total count of borrower_deleted?
Thanks,
Arul
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
95 | |
92 | |
86 | |
69 |
User | Count |
---|---|
162 | |
129 | |
125 | |
104 | |
98 |