Conditional Formatting in my Table Disappears when I add a Column

[huguestremblay]

Hello,

I have a report with a table where I need to highlight some values based on another field.  The conditional formatting works as expected until I add another column to the table, then the conditional formatting is not being applied to values without a values in the new column. 

I need to highlight (text in red) the sizes that are unavailable.  Both XX-Large and XX-Small are highlighted as I want in the left table.  When I add the count of sales to the table, the XX-Small is still red, but XX-Large, which has no sales, loses its conditional formatting. 

How can I make it stay red?

My report is available here: https://www.dropbox.com/scl/fi/kaehipx737w9528mh8cy9/Conditional-formatting.pbix?rlkey=x31ivvj3450rj...

Thank you!

[Kaviraj11 · Accepted solution]

I tried at my end and I would suggest you to create a measure of Count of Sales and utilize it in the table that will resolve your issues.

Count of Sale = COUNT(Sales[Sale])+0

[huguestremblay]

Thanks for the quick reply, it worked!