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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Hatim01
New Member

Problem in relationship

Hello,
I have a problem in the relations between the different tables.
I want to display the correct values of two measures.
The first is calculated using a field in the rotationdocument table and the second is calculated using the product taskdetails table.
When using strattask (a field in the rotationdocument table) the visual displays the correct value of the first measure and a false value of the second measure.model.PNG

1 REPLY 1
NickolajJessen
Solution Sage
Solution Sage

First things first. Bidirectional filters and many-to-many relationships are poison to your data model. I'd suggest watching your Youtuber of choice on creating data model and managing relationships in Power Bi. My preferred source is Avi Singh. If you get this right, you'll run into a lot fewer problems in the future.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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