Cannot Filter Course Instructor name for particular "Course A"

[Anonymous]

[tamerj1 · Accepted solution]

Hi @Anonymous 

please try

Instructor Name for MAT1 =

COALESCE (
MAXX (
FILTER ( 'Table', 'Table'[Completed Course] = "MAT1" ),
'Table'[Course Instructor Name]
),

"Test not found"

)

[Anonymous · Accepted solution]

Thank you so much. Your solution worked. Really appreciate your time and consideration.

[tamerj1 · Accepted solution]

Hi @Anonymous 

please try

Instructor Name for MAT1 =

COALESCE (
MAXX (
FILTER ( 'Table', 'Table'[Completed Course] = "MAT1" ),
'Table'[Course Instructor Name]
),

"Test not found"

)