Forum Discussion

bernate's avatar
bernate
Icon for Helper III rankHelper III
10 months ago
Solved

Calculate Other Trained Employees

Hello! I have 2 tables: Training and Employees. They are connected on Employee ID with a many to one relationship (many employee ID in Training table to 1 employee ID in Employee table) ...
Need Help
  • MasonMA's avatar
    MasonMA
    10 months ago

    Hi, if it is meant to return the number of distinct employees that completed the same training, you can try this measure, 

    _Other Trained =
    CALCULATE(
        DISTINCTCOUNT('Training'[Employee ID]),
        'Training'[Training Status] = "Complete",
        FILTER(
            'Training',
            'Training'[Training No.] = MAX('Training'[Training No.])
            && 'Training'[Training Name] = MAX('Training'[Training Name])
        )
    )

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
10 months ago

There should be a Many to One relationship from table 2 to table 1