Forum Discussion

bernate's avatar
bernate
Icon for Helper III rankHelper III
11 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
    11 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])
        )
    )

     

Anonymous's avatar
Anonymous
Not applicable
11 months ago

Hi bernate ,

 

Thank you  Khashayar and  MasonMA  for the response provided! 

 

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

 

Thank you for your understanding!