Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Mesaure diff between two coloumns

I have two data table, one with total employee number  and one table that shows those who are Sick with two columns one with date and the other one with employee number. Now I want to see how many of the total employee number are sick in procentage?

Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

     

    measure = COUNT(TABLE_NAME_2[Employee_Numner]) / COUNT(TABLE_NAME_1[Employee_Number])

     

     

    Table_name_2 refers to the ones who are sick

    Table_name_1 refers to all employees

2 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

    Could you please offer me some sample data if possible?

     

    Regards,
    Daniel He

  • themistoklis's avatar
    themistoklis
    Community Champion
    7 years ago

     

    measure = COUNT(TABLE_NAME_2[Employee_Numner]) / COUNT(TABLE_NAME_1[Employee_Number])

     

     

    Table_name_2 refers to the ones who are sick

    Table_name_1 refers to all employees