cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Measure instead of merging 3 tables

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.

Jonas

1 ACCEPTED SOLUTION
Community Support

Hi @J_o_n_a_s ,

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.

4 REPLIES 4
Community Support

Hi @J_o_n_a_s ,

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.

Helper I

Thank you 😀

Super User

@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

Helper I

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

Announcements

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors