Conditional Formatting for values not equal to 0 is not working properly

Question

I am trying to highlight the Discrepancies in my data where the values not being equal to 0 should be highlighted red. But the problem is that some rows that have the value 0, are also being highlighted.

The rule I wrote is:

The Conditional formatting shows up like this:

jihwan_kim · Answer

Hi, I am not sure how your semantic model looks like, but please try using ROUND DAX function whether it suits your requirement.
&nbsp;
ROUND function (DAX) - DAX | Microsoft Learn
&nbsp;

anonymous · Answer

Hi&nbsp;zyeet&nbsp;Based on the information you provided me, I think the problem may be in -1e+3!, you can change it to a numeric type like -1000 so that there is no problem associated with it.Turn -1e+3! into -1000.&nbsp; &nbsp; &nbsp;2. All 0.00 are become the same color.&nbsp;How to Get Your Question Answered Quickly&nbsp;If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .&nbsp;Best RegardsYilong ZhouIf this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

zyeet · Answer

I have tried your solution but not all my 0's are being formatted green:&nbsp;You can check the pbix file here:Draft Comparison Report.pbix

anonymous · Answer

Hi, zyeet
Based on the information you have provided, Here are my answers to your questions.
I opened your pbix file and found that there were indeed some 0.00s that didn't meet the green condition, so I rewrote a Color's Measure that returns green when the value of Variance is not equal to 0, and what I got was also that there were a lot of rows of 0.00s that turned green, which indicates that these values are not equal to 0.

&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
How to Get Your Question Answered Quickly&nbsp;
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Yilong Zhou
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.