Relationship and selection issue

[DivakarKrishnan]

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.

[DivakarKrishnan · Accepted solution]

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]

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? 

[DivakarKrishnan]

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

[EricHulshof]

@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.