separate values between invoice date and order date

[#1]

Hi a new problem for me

i have a pivot table

dimension: itemID

expression1: sum(ORDERlinemaount)

expression2 sum(invoicesalesbalance)

there are two tables

1table: here are my orders with the salesid and the order date sorted by salesid and itemid

2table here are the invoices with the same salesid but the invoices are not sorted by the itemid only the summary of a salesid

i made a mastercalendar for the invoicedate and the orderdate

how can i realize that when i select in the master invoicedate the values for the invoicedate are independent from the selection of the orderdate (values)

[#2]

Could please provide the table or data for more clarity on the issue.

[chrismarlow]

If your model is associating wouldn't you need 2 (disconnected from each other) calendars? So simplified;