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?