Count using a where

[Anonymous]

Hi, 

I need to create a new measure to apply the following logic, can anyone please help with with the correct DAX syntax please?

Count distinct cust_no where dept_no = 0

[Anonymous · Accepted solution]

Hello @Anonymous 
Please try the below code.

Total Count =
CALCULATE(
                   DISTINCTCOUNT(Table[cust_no]),
                   Table[dept_no] = 0
)