Forum Discussion
Creating relationships between one to multiple tables
The reason for the error message is, that you enabeld "Cross filter direction" into "both" directions.
Change this option to "single" for your existing relationships - then you are allowed to create more relationships on your "_filter" tables.
(I uploaded a corrected verision of your pbix-file to your onedrive share.)
Does this solve your issue?
The reason for the error message is, that you enabeld "Cross filter direction" into "both" directions.
Change this option to "single" for your existing relationships - then you are allowed to create more relationships on your "_filter" tables.
(I uploaded a corrected verision of your pbix-file to your onedrive share.)
Does this solve your issue?
I couldn't find the file you uploaded, but I did the changes in my own and it works, thank you!
I tried changing it to single and both too, but I haven't touched the calendar table's relationships, and the 'both's there were the problem, between the YYYYMM columns.