Forum Discussion
Using countblank in one column and get a distinct count of another column values
I created the countblank measure below, but I ultimately would like a distinct count on the number of students who are missing a value in the Student Ethnic Group Name field. Missing Ethnicity ...
You can try the following measure that takes a distinct count of student IDs when the ethnic group name is blank.
Missing Ethnicity =CALCULATE(DISTINCTCOUNT('86362'[Student ID]),OR(ISBLANK('86362'[Student Ethnic Group Name]), '86362'[Student Ethnic Group Name] = ""))Yep.
Amend the measure to
Missing Ethnicity =var _calc =CALCULATE(DISTINCTCOUNT('86362'[Student ID]),OR(ISBLANK('86362'[Student Ethnic Group Name]), '86362'[Student Ethnic Group Name] = ""))ReturnIF(ISBLANK(_calc),0,_calc)
