Forum Discussion
Solved
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 t...
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.