The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
User | Count |
---|---|
109 | |
82 | |
74 | |
53 | |
49 |
User | Count |
---|---|
133 | |
97 | |
94 | |
71 | |
69 |