Count zero in multiple Columns & exclude blanks

[Anonymous]

Hi All

I have a situation here please see below screenshot

Have created this table in power BI using sample data(link here). Now i want to create a measure which gives me distinct count of account number where "Sum of ABS YTD value is Zero in each of the year column (yellow highlighted one)" and "this should not count those cells where value is blank (red highlighted)". Any help? here is sample data link.

[v-diye-msft]

Hi @Anonymous 

let me know if you'd like to get this one:

Measure = CALCULATE(DISTINCTCOUNT(Sheet1[Account Number]),FILTER(Sheet1,[ABS YTD Value]=0))

Pbix attached. 

[Anonymous]

Hi @v-diye-msft 

This is not correct count as per my requirement. See below table i created in the pbix you shared, its still counting the blank values as i have indicated lines in red -

Requirement is to count only those account where value is "0" in all 3 years as highlighted in green above. If any year is having a blank value, it should not be counted.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Got it, kindly check my updated one:

Pbix attached.