Forum Discussion
Solved
Calculated Measure that Filters Another Table
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 PR...
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 , 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))
Perfect, thanks!
