Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
dustdaniel
Helper I
Helper I

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. 

 

dustdaniel_1-1725486081517.png

 

Here is the model view map

dustdaniel_0-1725485690906.png

 

Here is the File sample

I'll appreciate the explanation since I want to keep learning everyday.

1 ACCEPTED SOLUTION
dustdaniel
Helper I
Helper I

Finally I solve it, Looks like I was using the Userrelationship function incorrectly in the measures, at this point looks greate.

View solution in original post

6 REPLIES 6
dustdaniel
Helper I
Helper I

Finally I solve it, Looks like I was using the Userrelationship function incorrectly in the measures, at this point looks greate.

danextian
Super User
Super User

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.










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

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

 

dustdaniel_0-1725554786255.png

dustdaniel_1-1725554837833.png

 

dustdaniel_2-1725555142526.png

 

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

dustdaniel_1-1725574777784.png

 

dustdaniel_0-1725574695034.png

 

I think you've fixed it. The file is no longer accessible.

danextian_0-1725605016161.png

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Hi, I just removed the restriction of the file. Please check again

 

File sample 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.