if

i have two columns "Student ID" & "Status" in database, need a calculation to show colour on a card(Overall status) based on below conditions Condition: IF all student have "Pass" status the show...

Need Help

Samarth_18

4 years ago

Hi Anonymous

Create a measure like below for overall status:-

Measure 3 = if(COUNTROWS(FILTER('Table (3)','Table (3)'[Status] = "Fail"))>0,"Fail","Pass")

Now create a measure with below code and use it in conditional formatting:-

Measure =
IF (
    COUNTROWS ( FILTER ( 'Table (3)', 'Table (3)'[Status] = "Fail" ) ) > 0,
    "Red",
    "Green"
)

Output:-

Thanks,

Samarth

Forum Discussion

if