title: Why is my conditional formatting not working properly in PowerBI?
body: <p>I am trying to add conditional formatting into my table and although it works for some of the data, about half of it is not returning any value for the condition.</p>
  <pre><code>    Condition = MAXX('2020 PNRs', 
     IF('2020 PNRs'[2020-2021] &lt;=1, 1,
          IF('2020 PNRs'[2020-2021] &lt;=10000 , 2,
              IF('2020 PNRs'[2020-2021] &gt;10000 , 3)))) 
  </code></pre>
  <p>2020-2021 is a calculated measure</p>
  <pre><code>2020-2021 = 
  SUM('TTV'[2020TTV]) + SUM('TTV'[2021TTV])
  </code></pre>
  <p>but it is quite simple so I am not sure if that has anything to do with why it's not working?</p>
  <p><a href="https://i.stack.imgur.com/IRtcX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IRtcX.png" alt="Here you can see where it works for some and not others " /></a></p>