SUMMARIZE with COUNTROWS and FILTERS

[dolevh]

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!

[SpartaBI · Accepted solution]

@dolevh 
MEASURE = CALCULATE(DISTINCTCOUNT('CusTable'[RecordID]),'CusTable'[NewColumn] = 0)
 

Showcase Report – Contoso By SpartaBI

     

[dolevh]

Hi, 
it's working, Thanks!

[SpartaBI]

@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?