create flag using complex if condition in power query

Hi rob_vander2 ,You could achive this by custom column and if condition please try these 

1. Add a Custom Column:
   • Go to the "Add Column" tab and select "Custom Column."
   • Formula:
     if [Count] = null then 1
     else if [Count] = 1 and ([Ref] = 11 or [Ref] = 21 or [Ref] = 3) then 1
     else if [Count] = 2 and [Type] = "B" then 1
     else null
     
     

2. Filter the Rows:

   • After adding the Flag column, filter out rows where the Flag is null if you only want flagged rows in the final output.
     If this post helped please do give a kudos and accept this as a solution 
     Thanks In Advance

Hi rob_vander2 , here's a solution you can check out. I'll attach a snippet of M code I used. Thanks