2 fields checker- Request for alternative option in Power Query or Power Pivot

Hi Experts & Gurus,

I have a list with some agent names and HGH codes along with the revenue.
GDS has around 20 unique codes, I would like to get the revenue of agents who is only handling 2 particulars HGH codes (1S and 1B).
I have used some basic formulas and got the result in my test file. But the real data is huge and it takes a lot of time to run the sheet.
Could you please help me to solve this using power query or power pivot tools?

Please try formula at
G8
=SORT(FILTER(UNIQUE(A2:A28),MMULT(COUNTIFS(A2:A28,UNIQUE(A2:A28),B2:B28,{"1B","1S"}),{1;1})=COUNTIFS(A2:A28,UNIQUE(A2:A28))))
H8
=MMULT(SUMIFS($C$2:$C$28,A2:A28,G8#,B2:B28,{"1B","1S"}),{1;1})

or single-cell formula with let
=LET(Agent,A2:A28,High,B2:B28,u,UNIQUE(Agent),c,{"1B","1S"},Ua,SORT(FILTER(u,MMULT(COUNTIFS(Agent,u,High,c),{1;1})=COUNTIFS(Agent,u))),
CHOOSE({1,2},Ua,MMULT(SUMIFS(C2:C28,Agent,Ua,High,c),{1;1})))

Power Query

Please Login or Register  to view this content.

DAX measure
=if(CALCULATE( Sum(Table1[Revenue]), Table1[HGH]<>"1B",Table1[HGH]<>"1S")=0,
CALCULATE( Sum(Table1[Revenue]), Table1[HGH] in { "1B","1S"}))

Thanks a ton.

Can you please explain me how the grouping done in Power Query?

Please see step by step on this Query

Please Login or Register  to view this content.

SbS.png

Thank you.
That means, we should have knowledge on M Language, right?