Using inactive relationship in visuals

Hi all,

I have a question about inactive relationships. I have following tables:
- fact_order with:

- 1 active relationship to dim_customer
- 1 active relationship to dim_date (order_date) and 1 inactive relationship to dim_date (ship_date)
- 1 active relationship to dim_product

- fact_picking with:

- 1 active relationship to dim_date (pick_date)
- 1 active relationship to dim_product
- 1 inactive relationship to fact_order => I can't put this one active because I get an ambiguity error on column dim_product. I've tried setting that relationship inactive but then
I've got the same error message with the dim_date column.

I was wondering if the current way the relationships are set up is fine?
Because I can't set the relationship between fact_order and fact_picking active, I've encountered following problems:

- I needed to create a calculated measure for a visualisation of picks by customer to be able to specify the 'userelationship'. Problem with using calculated measures is that I can't see
the records in detail anymore if I want to dig deeper
- I want to have a table visualisation that consist of fact_picking[quantity_picked], fact_order[order_id], dim_customer[customer_name]. Here I get the error that it's unable to show the data because there's no (active)
relationship between those columns.

Can anyone give me some pointers to how to fix the issues?

Thanks in advance