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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
answeriver
Helper IV
Helper IV

Calendarauto Relationship

Hello friends,

 

Can you please teach me. What is right way do relationship with calendar auto table with other two tables but with relationship between them?Capture.JPG

1 ACCEPTED SOLUTION

Hi @answeriver ,

 

Relationship in power bi is different than other databases, it has direction for relationships(e.g, single filter direction, filter effect from one side to other side; cross filter direction, each side can effect correspond column).

 

Power bi will try to analytics data model and summary records through relationships.

 

If your relationship map contains multiple active relationships to analytic summarize, it will confused which one should be the right one. So it only allow one activated major relationship link between linked tables for analytics and interactions.

 

Assuming we set the relationship to active, we can see that the Calendar table can filter the SALES table from two paths, which is not allowed in Power BI.

 

Screenshot 2022-03-08 095133.png

 

You can set the direction between table Status File and table ACTIVE WS/SALES to "Single". 

 

vkkfmsft_0-1646705162809.png

 

Or use the USERELATIONSHIP function to make the relationship between the Calendar table and the SALES table active.

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

4 REPLIES 4
answeriver
Helper IV
Helper IV

After search in internet i tra to make right way for relationship in model. And then i get same problem i can't make relationship/ Please see the photoCapture1.JPGCapture.JPG

Actualy i need filters fact table by dim tables and also by date (calendar)

Hi @answeriver ,

 

Relationship in power bi is different than other databases, it has direction for relationships(e.g, single filter direction, filter effect from one side to other side; cross filter direction, each side can effect correspond column).

 

Power bi will try to analytics data model and summary records through relationships.

 

If your relationship map contains multiple active relationships to analytic summarize, it will confused which one should be the right one. So it only allow one activated major relationship link between linked tables for analytics and interactions.

 

Assuming we set the relationship to active, we can see that the Calendar table can filter the SALES table from two paths, which is not allowed in Power BI.

 

Screenshot 2022-03-08 095133.png

 

You can set the direction between table Status File and table ACTIVE WS/SALES to "Single". 

 

vkkfmsft_0-1646705162809.png

 

Or use the USERELATIONSHIP function to make the relationship between the Calendar table and the SALES table active.

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

amitchandak
Super User
Super User

@answeriver , when you try to make it active, what error does it give ?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.