Get Distinct count of one column based on the values of other column

[anandmitta]

Hi,

I have a table with 2 columns (ID, status)

I want to get the distinct count of ID whose status is blank

ID	STATUS
1	Passed
2	Passed
3
3
4	Passed
5
6	Passed

I want the output to be: 2 (Distinct Count of ID that have status as blank)

I have tried with different measures I was not able to get the output. 

Can someone please help me on the same.

Thanks,

Anand

[Greg_Deckler · Accepted solution]

@anandmitta Try:

Measure =
  VAR __Table = FILTER('Table',[STATUS] = BLANK()) //or try = ""
RETURN
  COUNTROWS(DISTINCT(SELECTCOLUMNS(__Table,"ID",[ID])))

[anandmitta]

Thank You so much!!!! It worked