Forum Discussion
Issue with fact and dimension table
Finally I solve it, Looks like I was using the Userrelationship function incorrectly in the measures, at this point looks greate.
In this case i think is not what you mentioned. In the next screenshot, the table on the left includes the dates from the fact table and there is only one row for Jan/01st but if I use the Date from date table as per on the right, its showing 3 rows that actually are from different dates
PD: kindly reminder that the sample file should be with no restriction at this moment - Thanks
I'm getting closer, just noticed that the issue is due to "ambiguous paths between tables" This is the warning I'm getting if I try to switch the relationship to active.
If I deactivate one and activate the other one manually, the issue just moves to other relationship and it's other visuals affected.
Need help please
I think you've fixed it. The file is no longer accessible.
