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.
Solved! Go to Solution.
solved with the following
CountItem = CALCULATE (
DISTINCTCOUNT (TblName[itemnumber] );TblName[Status]="Open")
Worked perfectly! Thank you so much!
solved with the following
CountItem = CALCULATE (
DISTINCTCOUNT (TblName[itemnumber] );TblName[Status]="Open")
Hi @Anonymous ,
I used the same DAX you posted, however I received a result of one when it should've been two. What am I doing incorrectly? Here is my DAX expression:
This work with me In measure (correct value) but On column, it gives a wrong value , why ?
Hi,
Without seeing some example data this isn't all that clear. If you have two possible text values in a column then distinct count will only return 0,1,2 depending on your filters. Is this your desired result?
It might seem a bit obvious but does DISTINCTCOUNT([Your Column Name] return what you need?
Thanks
Thomas
Thanks. I came to this post looking for help finding the number of distinct values in a column and the DISTINCTCOUNT function did work for me.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |