Forum Discussion
DAX IF statement help
Hi acalderon
I hope this would help you.
Dax Function:
Overall Status = IF(OR(OR(Sheet1[Budget status]="Red",Sheet1[Schedule status]="Red"),Sheet1[Scope status]="Red"),"Red",IF(OR(OR(Sheet1[Budget status]="Yellow",Sheet1[Schedule status]="Yellow"),Sheet1[Scope status]="Yellow"),"Yellow","Green"))
Report Link for your reference: https://app.powerbi.com/groups/me/reports/b1a5f4ce-0642-4844-b828-b2563e768479?ctid=470e1ac4-5b55-48e8-b282-4522b5248639
Probably best to create a measure that looks at each of the columns and checks if any of them are red, and also create a measure that looks at all of the columns and sees if any of them are yellow. You can then do something like:
OverallStatus = if([redcheck]=TRUE(), "Red",if([yellowcheck]=TRUE(), "Yellow", "Green"))