Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Cannot Filter Course Instructor name for particular "Course A"

 

  • Hi Anonymous 

    please try

    Instructor Name for MAT1 =

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

    "Test not found"

    )

  • Anonymous's avatar
    Anonymous
    3 years ago

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

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

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

     

  • tamerj1's avatar
    tamerj1
    Community Champion

    Hi Anonymous 

    please try

    Instructor Name for MAT1 =

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

    "Test not found"

    )