Forum Discussion
Active and Inactive Relation Filtration Context
Hi,
I have following tables and their relationship.
Issue is that on PowerBI report, I am not sure how to pesent both order and CreditMemo on same page filtered by Date. Orders get filtered by date and Credit Memo get filter by Order context. Cannot activate CreditMemo to date relationship due to circular dependency.
Currently in catch 22 situation...
Hi, Anonymous
If you want to both filter Order and CreditMemo by field Date on a same visual, you need to:1. active the relationship between the Table 'Date' and Table 'Order'
2. active the relationship between the Table 'Date' and Table 'CreditMemo'
3. inactive the relationship between table Table 'Order' and table Table 'CreditMemo'
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Anonymous , Either you should merge order and credit memo and create a table that has all required columns, say Order credit memo. Now you can use only this one table or use the Order credit memo Or use two facts Order credit memo and Order not joining to each other.
Discussed this concept here - https://youtu.be/kXls79iNPqc?t=1691
Hi, Anonymous
If you want to both filter Order and CreditMemo by field Date on a same visual, you need to:1. active the relationship between the Table 'Date' and Table 'Order'
2. active the relationship between the Table 'Date' and Table 'CreditMemo'
3. inactive the relationship between table Table 'Order' and table Table 'CreditMemo'
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
