Status based on score

You can achieve this using a calculated column with a combination of CALCULATE, FILTER, and MINX. Here's one way to do it:

Status = 
VAR CurrentStudent = 'Student'[Student Name]
VAR MinScore = 
    CALCULATE(
        MINX(FILTER('Student', 'Student'[Student Name] = CurrentStudent), 'Student'[Score])
    )
RETURN IF(MinScore < 40, "BAD", "GOOD")

This logic checks the minimum score for each student across all their subjects. If it's below 40, it flags all rows for that student as "BAD", otherwise "GOOD".

Let me know if your actual table structure is different or if you're using a different name for the table — this can be adjusted easily.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

*This response was supported by AI for translation and text editing purposes.