Bottom N based on Condition

Hi AyeshaA10 ,

You can use filters in your case to showcase your results:

Hope this helps, please let me know if this doesnot work out.

Create a measure like

Is At Risk =
VAR CurrentStudent =
    SELECTEDVALUE ( 'Grading Data'[Student ID] )
VAR AtRiskStudents =
    TOPN ( 10, ALL ( 'Grading Data' ), 'Grading Data'[Total], ASC )
VAR VisibleAtRiskStudents =
    SELECTCOLUMNS (
        FILTER ( AtRiskStudents, 'Grading Data'[Total] < 50 ),
        'Grading Data'[Student ID]
    )
VAR Result =
    IF ( CurrentStudent IN VisibleAtRiskStudents, 1 )
RETURN
    Result

and add this as a visual level filter to only show when the value is 1

Thank you very much for your help! I've saved this DAX measure. I think this is going to come in handy later.