Containssting

Hi,

You can use: 

OverdueSummary =
VAR StatusValue = TRIM(UPPER('Combined'[Status]))
VAR LoadoutValue = TRIM(UPPER('Combined'[Loadout]))
RETURN
IF(
    StatusValue = "OVERDUE" || LoadoutValue = "OVERDUE",
    "OVERDUE",
    BLANK()
)

Let me know if that worked.

If this helped, mark this answer as a solution. Kudos are appreciated!

AllanBerces 

OverdueSummary = 
VAR IsStatusOverdue = COALESCE(CONTAINSSTRING('Combined'[Status], "OVERDUE"), FALSE)
VAR IsLoadoutOverdue = COALESCE(CONTAINSSTRING('Combined'[Loadout], "OVERDUE"), FALSE)
RETURN IF(IsStatusOverdue || IsLoadoutOverdue, "OVERDUE", BLANK())

If rows still show wrong, your source text likely has extra spaces. Wrap each column in TRIM:

CONTAINSSTRING(TRIM('Combined'[Status]), "OVERDUE")

If this answer helped, please click 👍 or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande