title: Power BI multiple conditions for countifs
body: <p>I am trying to achieve the countifs here for the following combination item and code.</p>
  <p>Column A&amp;B has Item and code and column C my status.</p>
  <p>1.if same item has &quot;YP&quot; after the code and there is no &quot;YP&quot; after the code then my status is &quot;NotOKay&quot;.</p>
  <p>Example;</p>
  <p><img src="https://i.stack.imgur.com/5Hmh8.png" alt="enter image description here" /></p>
  <p>2.There is no &quot;YP&quot; after the code for the same item then my status is &quot;Okay&quot;.</p>
  <p><img src="https://i.stack.imgur.com/f4BWo.png" alt="enter image description here" /></p>
  <p><img src="https://i.stack.imgur.com/czdSr.png" alt="enter image description here" /></p>
  <p><a href="https://i.stack.imgur.com/A0M9U.png" rel="nofollow noreferrer">enter image description here</a></p>