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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
osinquinvdm
Advocate II
Advocate II

Why does the relationship not work anymore?

2017-03-28 14_19_19-311-dashboard - Power BI Desktop.png

To make it easy to switch time ranges I created selector that let you select among 6 “temporalities”:  this week, this month, this year etc…

 

It is based on 2 extra tables, one, called “Calendar”  that associates each date with the relevant 6 temporality it can be associated with; and a relationship table that contains all the dates and is associated with the dates in calendar on one side and with the event date in the fact tables (actually with 2 dates, the open date and the close date, hence the 2 lines, one dotted, below)

 

2017-03-28 14_22_26-311-dashboard - Power BI Desktop.png

 

This worked like a charm until I refreshed the data this morning.

I did not change anything to the data model.

The only thing I did is removing the use of USERELATIONSHIP with 2 measures and remove/restore relationships in the project (at some point there was a glitch in the data load that suggested there might be an issue with those metrics).

But today everything is restored as it was yesterday so I don’t understand why

  • The Calendar to AllDates relationship works
  • The Fact table to AllDates relationship works
  • The Fact table to Calendar relationship does not work anymore

Again, it worked as expected; I could pick a temporality from the Calendar table and filter on the related subset in the fact table.

 

What could have possibly happened?

2 REPLIES 2
Dog
Responsive Resident
Responsive Resident

Hi @osinquinvdm,

 

is it possibly down to the cross filtering direction on the relationship. 

 

The 1 to many direction would suggest that the alldates tables filters the table containing the temporalites and not the other way around. 

 

I'm wondering if data refresh has changed the relationship dynamics? 

 

what are the from and to columns on the relationship?

 

 

v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Hi @osinquinvdm

Which relationship do you remove in your data model? Are you unable to filter your visual in the case? If that is the case, please share sample data of your tables and detailed DAX you use to create measures for us to analyze.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 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.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors