Forum Discussion
Issue with fact and dimension table
Hi theres.
I'm having issues with the relationship between date table and 'ResultadosEncuesta' table, as you can see I have 60 surveys with no dates in the matrix but in the fact table they have a date correctly.
Here is the model view map
Here is the File sample
I'll appreciate the explanation since I want to keep learning everyday.
Finally I solve it, Looks like I was using the Userrelationship function incorrectly in the measures, at this point looks greate.
6 Replies
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
Finally I solve it, Looks like I was using the Userrelationship function incorrectly in the measures, at this point looks greate.
