Measure instead of merging 3 tables

[J_o_n_a_s]

Hi all,

I have a table (showing employee hours worked) with about 250k rows. Instead of merging it with 2 other tables I assume using a measure loads my reports faster. (If not I will stick to merging the tables).

So basically i have these 3 tables below. The yellow columns are the result after merging the 3 tables. So i would like a measure to replicate that merge.

Thanks for your help.
Jonas

[v-jianboli-msft · Accepted solution]

Hi @J_o_n_a_s ,

Please try:

First, create relationships between the three tables:

Then apply the measures to the table visual:

Department(Employee) = CALCULATE( MAX('Table 1'[Department]),FILTER('Table 1',[Employee]=MAX('Table 3'[Employee])))



Department(Project) = CALCULATE( MAX('Table 2'[Department]),FILTER('Table 2',[Project]=MAX('Table 3'[Project])))

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[J_o_n_a_s]

Thank you 😀

[amitchandak]

@J_o_n_a_s , Join Table 3 with Table 2 and Table 1 on the project and employee respectively.

Then simply create a measure sum(Table3[Hours])

and display along with columns from table 1, Table 3

[J_o_n_a_s]

Thanks @amitchandak . But your method makes use of merging. I am trying to find a way of not having those yellow columns in table 3. But having a measure instead.

Thanks

Jonas