Conditionally format a measure based on another measure
Sometimes we would like to color code a measure (A) not by its performance rather by another measure's (B) performance. The problem is that when applying the conditional formatting on measure A, the measure A is static in the equation.
To work around this, one will need to take measure B function into consideration into the conditional formatting calculation of the measure A, and move it to the other side of the equation. You need to color A according to B, if A is above or 2000:
What you need - A>2000
What you have is B static on the left hand side of the equation, so you need to multiply by B and divide by A :
B>(B/A)*2000 => B/B>(B/A)*2000/B => 1>2000/A => A>2000
See screenshot and attached dash file
Always here to help 🙂
Ido
QBeeQ - Gold Implementation & Development Partner
