Using two different relationships between the same two tables in the same measure - how?

Hi D_PBI, you can use USERELATIONSHIP -> https://learn.microsoft.com/en-us/dax/userelationship-function-dax

CALCULATETABLE(
    agreement,
    dimDate[Date] >= [Start Date] && dimDate[Date] <= [End Date],  -- Filters ExecutionDate
    USERELATIONSHIP(dimDate[Date], agreement[ReceivedDate])        -- Filters ReceivedDate
)

If I answered your question, please mark it as Solution

Hello D_PBI 

Check out this guide on managing multiple date relationships in Power BI.

FilteredTable =
CALCULATETABLE(
'Agreement',
USERELATIONSHIP(dimDate[Date], Agreement[ReceivedDate]),
Agreement[ExecutionDate] >= [MinDate],
Agreement[ExecutionDate] <= [MaxDate]
)

Regards,

Ritesh

Community Champion

Please mark the answer if helpful so that it can help others

Dance-Sing with Data Projects - YouTube