Active and Inactive Relation Filtration Context

[RamiSingh]

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

[v-easonf-msft · Accepted solution]

Hi, @RamiSingh 
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.

[amitchandak]

@RamiSingh , 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