Calculated Measure that Filters Another Table

[oliverblane]

I have two tables that look like the following. Table1:

Table2:

My aim is to have a measure that calculates the distinct count of PRN where the Course Status is 1. Without adding the PRN column to Table1, how could I go about doing this?

Thanks for your help!

[amitchandak · Accepted solution]

@oliverblane , Try a measure like

Var _1 = summarize(filter(Table1, Table[Course Status] =1), Table1[ID])
return
calculate(DISTINCTCOUNT(Table2[PRN]), filter(Table2, Table2[ID] in _1))

[oliverblane]

Perfect, thanks!