How to use same date cross different tables

[ninawang99]

Hi All,

If my calendar use DATE from employee roster table as data source, while when check the order number on specific date, I used below expression, but it doesn't work

count( {<OrderDT = {'$(=GetFieldSelections(DATE))'}>}  distinct OrderID)

My data from two tables like below, the first table recorded employee roster, and the second table recorded order IDs on that day.

Is there any way if I select the DATE from the roster table and get the order numbers on that day?

Thanks

Nina

[panosalexand]

Hello, I think order table must be connected with calendar also.  I'm not sure if the Date field from employee table need to be connected with the calendar. Also check if there is a key common element between 2 tables and create a relationship. 

Thanks

[AronC]

I don't know if you have more complexity, but normally if you have several types of  transactions in the same model,  the easiest way is to concatenate the two source-tables. Then you only have one fact-table and one date-field.