Forum Discussion
Distinct count based off two columns
Hello I am trying to create a measure that will distinct count based on more than one column. I want to count if 1). InProgram is = 1 AND 2) the program ID is distinct. I have included and exampl...
Hello please try :
Count of students = CALCULATE(DISTINCTCOUNT(lmyers31[Student ID]),FILTER(lmyers31,lmyers31[InProgram] = 1))And result:
if this helps, kindly accept as solution and a kudos is appreciated
This worked perfectly. Thank you so much!