Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filter using a measure with Distinct

Hello   I’ve have a table that contains student module data. A student can have multiple modules.  There is a Module_Passed flag that is either 0 or 1   There are measures (see attached code) to ...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

Create a measure sa below. If it doesn't meet your requirement, kindly share your excepted result to me.

 

Students with All Modules Passed2 = CALCULATE(DISTINCTCOUNT(Table1[Student_ID]),ALL(Table1))-CALCULATE(DISTINCTCOUNT(Table1[Student_ID]),FILTER(ALL(Table1),Table1[Module_Passed]=0))

 

Regards,

Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.


Regards,
Frank