Forum Discussion
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.
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!
4 Replies
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!
Anonymous: 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.
