cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
okletsgo Frequent Visitor
Frequent Visitor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
themistoklis New Contributor
New Contributor

Re: Mesaure diff between two coloumns

 

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 2
Community Support Team
Community Support Team

Re: Mesaure diff between two coloumns

Hi @okletsgo,

Could you please offer me some sample data if possible?

 

Regards,
Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
themistoklis New Contributor
New Contributor

Re: Mesaure diff between two coloumns

 

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