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 All,
I have this table (CusTable) :
RecordID | Date | NewColumn |
123 | 1/1/2022 | 1 |
123 | 2/1/2002 | 0 |
123 | 3/1/2022 | 0 |
123456 | 1/1/2022 | 1 |
123456 | 2/1/2002 | 0 |
123456 | 3/1/2022 | 0 |
123456 | 4/1/2022 | 0 |
123456789 | 1/1/2022 | 1 |
123456789 | 2/1/2002 | 0 |
234 | 1/1/2022 | 1 |
567 | 1/1/2022 | 1 |
I'm looking for dax that shows me if any RecordID has the num "0" so counting them but only one time. for example in my
table counting the num is "3"
thanks all!
Solved! Go to Solution.
@dolevh
MEASURE = CALCULATE(DISTINCTCOUNT('CusTable'[RecordID]),'CusTable'[NewColumn] = 0)
@dolevh
MEASURE = CALCULATE(DISTINCTCOUNT('CusTable'[RecordID]),'CusTable'[NewColumn] = 0)
Hi,
it's working, Thanks!
@dolevh where did you put that measure? (In the model table/ in a visual?)
Can you share a fake screenshot of the result you want to get?
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 |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |