calculate with multiple filters and circular dependancies

[Unicorn_Tech]

I have licenses with many contracts.  I want to calculate which contract is the latest (most recent signature date), filtered by those that have a payment above 1, and have a stage type greater than 100001000 (this excludes irrelevant contracts from the result.

I was able to do a column where the latest date was returned with the filter of the license value:

Most Recent Contract = calculate(max(new_contracts[new_signature_date].[Date]),
Filter(new_contracts,new_contracts[_new_license_value] = new_licenses[new_licenseid]))

I cannot add multiple filters to this, or I don't know the way to.  My preference would be to add two more filters, one for payment above 1 and the stage type.

I tried making filtered tables as a solution, which is creating the circular dependancies.

Proper Contracts = 
Calculatetable(new_contracts,
Filter(new_contracts,new_contracts[new_contractstage]<100001000))

Paid Contracts = 
Calculatetable('Proper Contracts',
Filter('Proper Contracts','Proper Contracts'[new_budget]>0))

I would appreciate assistance in putting this together. The goal is to be able to properly flag the correct contract per license, being the latest, of certain types, with a budget above 1.

Thank you.

[Unicorn_Tech · Accepted solution]

I always end up making progress on these things after I post.  Now I've done the following column, finally getting the syntax right.

Most Recent Real Paid = CALCULATE(Max(new_contracts[new_signature_date]),
Filter(new_contracts,new_contracts[_new_license_value] = new_licenses[new_licenseid] &&
new_contracts[new_budget]>1&&
new_contracts[new_contractstage]<100001000
))