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

Regular Visitor

Creating a measure between two differents tables

Hi everyone,

I have two tables A and B.

A contains all the names and the contracts of all the employees. B contains all the possible types of contracts and the FTE referred to each contract.

The two tables are in realtion by the contracts column.

How can I obtain the total FTE of the entire company?

1 ACCEPTED SOLUTION

@Stevo164

In table A create this measure! It's works

FTE = SUMX(Table A; RELATED(Table B[FTE]))

5 REPLIES 5
Anonymous
Not applicable

You can create measure like this:

Total Company FTE = CALCULATE(SUM(B[FTE]), ALL(B))

This will display the total FTE ignoring any filters you have on your report page. If you want total FTE that filters by employee name, or contract type, use this:

Total FTE = SUM(B[FTE])

Regular Visitor

thank you @Anonymous,

but that doesn't work for me. It will only shows the total FTE per type of contract with no relation with the number of employees.

@Stevo164

In table A create this measure! It's works

FTE = SUMX(Table A; RELATED(Table B[FTE]))

Hey @Stevo164

I could not understand your question very well...

I think you want make group by types of contracts, right?

Regular Visitor

Hi @_picoloto43,

sorry for my bad english. Let give you and example:

TABLE A

 Employee Contract Employee 1 Contract 1 Employee 2 Contract 2 Employee 3 Contract 1 Employee 4 Contract 4 Employee 5 Contract 2 Employee 6 Contract 2 Employee 7 Contract 2 Employee 8 Contract 1 Employee 9 Contract 1 Employee 10 Contract 1 Employee 11 Contract 1 Employee 12 Contract 4 Employee 13 Contract 4 Employee 14 Contract 4 Employee 15 Contract 4 Employee 16 Contract 5 Employee 17 Contract 2 Employee 18 Contract 3 Employee 19 Contract 3

TABLE B

 Contract FTE Contract 1 0,9 Contract 2 0,8 Contract 3 0,7 Contract 4 0,6 Contract 5 0,5

The result should be 14,3

 Employee Contract FTE Employee 1 Contract 1 0,9 Employee 2 Contract 2 0,8 Employee 3 Contract 1 0,9 Employee 4 Contract 4 0,6 Employee 5 Contract 2 0,8 Employee 6 Contract 2 0,8 Employee 7 Contract 2 0,8 Employee 8 Contract 1 0,9 Employee 9 Contract 1 0,9 Employee 10 Contract 1 0,9 Employee 11 Contract 1 0,9 Employee 12 Contract 4 0,6 Employee 13 Contract 4 0,6 Employee 14 Contract 4 0,6 Employee 15 Contract 4 0,6 Employee 16 Contract 5 0,5 Employee 17 Contract 2 0,8 Employee 18 Contract 3 0,7 Employee 19 Contract 3 0,7

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - August 2024

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

Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors