Measure based on two unlinked tables

[David1205]

Hello all,

I have the following data sources:

Table 1: contains sales and profits by month/year/company/department/cost center.

Table 2: contains the number of employees by month/year/company/department/productive indicator.

I would like to calculate key figures based on these two tables (e.g. sales per employee).

For this I need slicers that allow me to filter month/year/company/department in both tables 1 and 2 at the same time.

Which possibility do I have here? Unfortunately, it is not possible to link the two tables 1 and 2.

Thanks a lot for your help!

[David1205]

What do you mean with 4 Dimension table? 

[tamerj1]

@David1205 

month/year/company/department Should be 4 dimension tables each linked to both main tables 

[tamerj1]

@David1205 

Can you at least create the 4 dimension tables and link them to both tables?