Forum Discussion

DianneB's avatar
DianneB
Frequent Visitor
3 years ago
Solved

Conditional formatting with different rules from different columns applied to same column

Hi,    I have the following table set up.  I want to set up conditional formatting that highlights cell values based on the following criteria.   If Sales A is greater than or equal to 5 highligh...
Need Help
  • DianneB's avatar
    DianneB
    3 years ago

    Wonderful - now are you able to tell me how I combine the two formulas into one DAX measure please.

v-kkf-msft's avatar
v-kkf-msft
Community Support
3 years ago

Hi DianneB ,

 

Please try these measures.

 

Color_A = 
var _a = SUM('Table'[Sales A])
var _b = SUM('Table'[Sales B])
return IF(_a + _b <= 12 && _a < 5, BLANK(), "blue")
Color_B = 
var _a = SUM('Table'[Sales A])
var _b = SUM('Table'[Sales B])
return IF(_a + _b <= 12 && _a < 5 && _b < 10, BLANK(), "blue")

 

Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DianneB's avatar
DianneB
Frequent Visitor
3 years ago

I have another question please - I have worked out the formula with your help but now want to use the same criteria to highlight costs but when I do so, blank cells will highlight because whilst the criteria will apply and only highlight cells which meet the criteria when I use as described, when I apply to something else even all cells highlight even if blank. Does this make sense?