Forum Discussion

Stevo164's avatar
Stevo164
Regular Visitor
8 years ago
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...
Need Help
  • _picoloto43's avatar
    _picoloto43
    8 years ago

    Stevo164

     

     

    In table A create this measure! It's works

     

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

Stevo164's avatar
Stevo164
Regular Visitor
8 years ago

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.

_picoloto43's avatar
_picoloto43
Advocate II
8 years ago

Stevo164

 

 

In table A create this measure! It's works

 

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