I am trying to get the below DAX calculation to work. Right now I’m getting an error on the last filter because it references a different table. What is the best way to work around this?

CALCULATE(SUM(transactions[AdvancedMD Units]), transactions[Billing Code] IN {“97153”, “97154”, “97155”, “97156”, “97151”, “97152”}, transactions[date_of_service] >= ‘auth records'[start_date])

I tried to use filtering on the card itself in PowerBI, but since each client has a different start date, that didn’t work.