DAX: Background colours for whole row

[LABrowne]

Hello there,

I am working on creating a table of sales orders. Sometimes we have orders that have later been cancelled but show up on the orders table. Usually someone will log this info with the order name and at the end put "- Cancelled" e.g. Sarah Jane - Cancelled. This is so we can see which orders have been cancelled. If an order has Cancelled at the end of it I want the whole row's background color to be Red. This what I have so far:

Background Cancellation Colours =
IF ( MAX (Orders[OrderName]) = "Cancelled" , "Red", BLANK())

I believe I am going wrong because no order name is just "Cancelled" it's just apart of it if there is a contains formula it might work.

Any help would be great!

Kind regards,

Luke

[FreemanZ · Accepted solution]

hi @LABrowne ,

try like:

Background Cancellation Colours =

IF ( CONTAINSSTRING(MAX (Orders[OrderName]), "Cancelled") , "Red", BLANK())

[LABrowne]

Thank you very much!