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.
Hi dustdaniel
Your file needs permission to access. That aside, the common reason why the blank is there are dates in your fact table that are not in the calendar table. Try adding the date from the fact table to the viz as well. Some will not have a match from the calendar.
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.