Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |