Master data file and master date file, can't link both. Suggestions?

[AlexJB]

Good afternoon,

I am looking for a solution for the a problem with a date table and a master data file. I have linked all my data files to a master data file because the files themselves would be too big to handle. Although now I also want to filter on months/ years in the visuals. To do this I need a master date file. But I cannot link this to all the files aswell. I cannot make all the links active. Which is ofcourse normal. But there must be some kind of solution for this. 

I hope it is clear. See below screenshot what I actually want but whats ofcourse impossible. I can't include dates in the master data file because thats filled with product information.

thanks in advance,

Alex

[v-yalanwu-msft · Accepted solution]

Hi, @AlexJB 
Since it is not possible to connect a closed-loop active relationship when establishing a relationship, you can change the both to single of your relationship, or use measure to solve the desired result display.

Or USERELATIONSHIP function (DAX) - DAX | Microsoft Docs

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.