Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
86 | |
82 | |
64 | |
49 |
User | Count |
---|---|
125 | |
111 | |
88 | |
69 | |
66 |