Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
In table A create this measure! It's works
FTE = SUMX(Table A; RELATED(Table B[FTE]))
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])
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.
Hey @Stevo164
I could not understand your question very well...
I think you want make group by types of contracts, right?
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 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |