SSAS Tabular Model Date Relationship Does Not Work For Some tables in Power BI

[MontherKH]

I have created SSAS Tabular Model, in this model there is a date dimension table.

After connecting to the model in Power BI, I am facing a problem that the Date relationship is working for some tables, but not for others.

I have made sure that the relationship is created on the correct fields, ensured that the relationship fields from both sides are of data type (Date) with the same format (M/d/yyyy), and all relationships are active.

I have also made sure that there are no slicers or filters affecting the behavior.

Below you can see a highlight of 2 tables, one of them works as intended with the date dimension, while the other doesn't.

The yellow outline shows the date dimension, the green outline shows a table that works successfully with the date dimension, the red outline shows a table that does not work with the date dimension.

Below you can see the result when I create 2 tables in Power BI with 2 columns, the year column from the date dimension, and a numerical value from the highlighted tables.

As you can see, the relationship works for the second one, but not for the first one.

[Anonymous]

Remove the relationship between the RenewRenewRequest and the PR_RenewRequestPA.. and see if it works then. 

If it does, there is confusion between the date dimension and the 2 tables(queries) because of the extra relationship.