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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DivakarKrishnan
Helper II
Helper II

Relationship and selection issue

Dear Team,

 

Need your support on this below issue.

 

I have two different tables in my model (stocks, delivery). I want to do some calculations for purchase, production, and delivery.

For delivery, already I have written all my calculations DAX and it is working properly in separate delivery report page and I would like to use all those calculations in this stocks report page as well. However, the values are not changing in my stocks page.

 

I have made many-to-many relationship with “movement type” field between these two tables and tried with “both” and “single” cross filter option but I am not getting desired results in my report page.

 

Please check the image below, I am choosing “Production” category but still it’s showing Delivery values whereas it should show only for “Delivery” category. Please advise how to achieve this.

 

 

Model Relationship Issue.png

1 ACCEPTED SOLUTION
DivakarKrishnan
Helper II
Helper II

This issue has been fixed, i have Calculate table applied some group by function over the delivery status table. I have made relationship with this calculate table and it's working fine. Thanks!

View solution in original post

4 REPLIES 4
DivakarKrishnan
Helper II
Helper II

This issue has been fixed, i have Calculate table applied some group by function over the delivery status table. I have made relationship with this calculate table and it's working fine. Thanks!

EricHulshof
Solution Sage
Solution Sage

Hey,

 

Im on a pretty small screen right now, but that relationship looks like it is inactive. Could you try and make the relationship active? 


Quality over Quantity


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


@EricHulshof: Relationship is active only, i have verified it again. Still it's not working..

@DivakarKrishnan Hmm, could you maybe send me a Power BI report with the problem? Then i can take a closer look at it. 

Please make sure their is no confidential data in the report. 


Quality over Quantity


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


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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