Ambiguity in date table

[unobasta]

Hi all,
 
I have a cost report with actuals and budget that should be filter based on cost center and date.

Each cost center is connected to a service and this service can change between years.

So, I need that Year field in Date table would filter also CostCenterList table. Problem is this will create an ambiguity between CostCenterList and the other tables.

 Any idea on how to solve this would be much appreciated.

Thank you in advance!

[v-eachen-msft]

Hi @unobasta ,

You could create an inactive relationship and use it with USERELATIONSHIP() function in DAX.

[adambhappy]

It seems like the simplest solution here is to handle it during import. 

1) Append the Budget/Actuals so that it becomes one table

2) Add a year column to the fact table

3) Merge the fact table with the cost center list using the year and cost center as columns

4) Add the service column to the fact table

Voila!