https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-Filter-Course-Instructor-name-for-particular-quot-Course/m-p/3109958#M109803 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P> <P>please try</P> <P>Instructor Name for MAT1 =</P> <P>COALESCE (<BR />MAXX (<BR />FILTER ( 'Table', 'Table'[Completed Course] = "MAT1" ),<BR />'Table'[Course Instructor Name]<BR />),</P> <P>"Test not found"</P> <P>)</P> Fri, 03 Mar 2023 09:55:11 GMT tamerj1 2023-03-03T09:55:11Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-Filter-Course-Instructor-name-for-particular-quot-Course/m-p/3109895#M109799 <P><img /></P><P>&nbsp;</P> Fri, 03 Mar 2023 09:21:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-Filter-Course-Instructor-name-for-particular-quot-Course/m-p/3109895#M109799 Anonymous 2023-03-03T09:21:03Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-Filter-Course-Instructor-name-for-particular-quot-Course/m-p/3109958#M109803 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;</P> <P>please try</P> <P>Instructor Name for MAT1 =</P> <P>COALESCE (<BR />MAXX (<BR />FILTER ( 'Table', 'Table'[Completed Course] = "MAT1" ),<BR />'Table'[Course Instructor Name]<BR />),</P> <P>"Test not found"</P> <P>)</P> Fri, 03 Mar 2023 09:55:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-Filter-Course-Instructor-name-for-particular-quot-Course/m-p/3109958#M109803 tamerj1 2023-03-03T09:55:11Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-Filter-Course-Instructor-name-for-particular-quot-Course/m-p/3110689#M109856 <P>Thank you so much. Your solution worked. Really appreciate your time and consideration.</P><P>&nbsp;</P> Fri, 03 Mar 2023 15:19:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cannot-Filter-Course-Instructor-name-for-particular-quot-Course/m-p/3110689#M109856 Anonymous 2023-03-03T15:19:58Z