if

[Anonymous]

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 Green Colour
                   If any single student have "Fail" status the show Green colour

Student id	Status
1	Pass
2	Fail
3	Pass
4	Pass
5	Pass

[Ankit89301]

This POWER BI, reply in any Measure or New Column 
Adults_type = IF(('all hotels'[adults] = 1 && 'all hotels'[children] = 0 && 'all hotels'[babies] = 0) ,"Single",

                    IF(('all hotels'[adults] = 2 && 'all hotels'[children] = 0 && 'all hotels'[babies]) = 0,"Couple",

                         IF(('all hotels'[adults] > 2 && 'all hotels'[children] = 0 && 'all hotels'[babies] = 0),"Group or Friends","Family"

                            )

                       )

                 )

[v-henryk-mstf]

Hi @Anonymous ,

Whether the advice given by @Samarth_18  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[Samarth_18 · Accepted solution]

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

[amitchandak]

@Anonymous ,

New measure =

var _color = countrows(filter(Allselected(Table), Table[Status] = "Fail"))

return

if(isblank(_color) , "Green", "Red")

Use this measure in conditional formatting using field value option