Forum Discussion
Solved
Status based on score
Hi, I have Student table( Student Name,Subject and Score) as the data below: Student Name Subject Score Student1 Subject1 50 Student1 Subject2 67 Student1 Subject3 50 Student...
pls try
Hi Jyaul1122, Hope you are doing good !
Please try the below dax to create calculated column:
VAR name = [Student Name]
RETURN
IF(COUNTROWS(
FILTER('Student table','Student table' [Student Name] = name && "Student table' [Score] <=40))>=1, "BAD", "GOOD")
If this post helps to answer your question, please consider accepting it as a solution so others can find it more quickly when they face a similar challenge.
Proud to be a Microsoft Fabric community super user
Let's Connect on LinkedIn
Subscribe to my YouTube channel for Microsoft Fabric and Power BI updates.