title: Occurence of a ID in every Year in PowerBI
body: <p>I have a data on a monthly base in PowerBI, which looks like this:</p>
  <pre><code>ID  Month  FY
  A    1     TY
  A    2     TY
  A    1     LY
  B    1     TY
  B    2     TY
  </code></pre>
  <p>How can I check if the ID occurs in every FY, in a new column?</p>
  <pre><code>ID  Month  FY  Marker
  A    1     TY  y
  A    2     TY  y
  A    1     LY  y
  B    1     TY  n
  B    2     TY  n
  </code></pre>
  <p>I try to use summarize, but I have no idea how to continue:</p>
  <pre><code>New column= summarize(data, ID, FY, &quot;Count&quot;, distinctcount(ID))
  </code></pre>