DAX conditional formatting

[Anonymous]

Hi all,

I am trying to create a measure for conditional formatting of background colour.

The conditional format is set up as the higher the better for most of my variables, however for four of my variables it should be the lower the better therefore the conditional formatting should be inverted.

Please see below the DAX I have so far;

Dynamic Background =

VAR red = "#e68f96"

VAR amber = "#ffd700"

VAR green = "#a4ff73"

VAR threshold = SWITCH(TRUE(),

VALUES('Readiness Unpivoted'[Test]) = "Sleep Quality", [Readiness Upper],

VALUES('Readiness Unpivoted'[Test]) = "Fatigue", [Readiness Upper],

VALUES('Readiness Unpivoted'[Test]) = "External Stress", [Readiness Upper],

VALUES('Readiness Unpivoted'[Test]) = "Muscle Soreness", [Readiness Upper],

[Readiness Lower])

VAR above = IF([Readiness Value] >= [Readiness AVG Selected], green)

VAR below = IF([Readiness Value] < threshold, red)

VAR between = IF([Readiness Value] <= [Readiness AVG Selected], IF([Readiness Value] >= threshold, amber))

I now need to invert the conditional format.

I hope this makes sense and thanks in advance.

Sean

[MattAllington]

You haven't provided ani info about the various  "readiness" measures, so it is hard to say. I suggest you investigate multiplying one of your measures by -1 to flip the biggest to smallest. It is hard to say where to do that given the info provided, but that is what I would be looking to do if it were me. 

[Anonymous]

Thanks for your reply. Apologies if I was not clear.

However I did manage to figure it out by using SWITCH to change the calculation for the four 'Readiness Tests'.