Forum Discussion
Measure based on 2 tables
I think this can be done fairly easily.
Just use "new measure" and use DISTINCTCOUNT('Hires'[ID])/(DISTINCTCOUNT('Hires'[ID])+DISTINCTCOUTN('Employees'[ID])). You may then want to format the measure as "%".
Please try it out and let us know if this works as I have not tested it myself.
Anonymous There are many ways, easiest and cleanest way is using variables and here is a screenshot of the same.
Hiring Rate = VAR EmpCount = CALCULATE(DISTINCTCOUNT(Employees[Country])) VAR HiresCount = CALCULATE(DISTINCTCOUNT(Hires[Country])) RETURN DIVIDE(HiresCount,EmpCount,0)
I think this can be done fairly easily.
Just use "new measure" and use DISTINCTCOUNT('Hires'[ID])/(DISTINCTCOUNT('Hires'[ID])+DISTINCTCOUTN('Employees'[ID])). You may then want to format the measure as "%".
Please try it out and let us know if this works as I have not tested it myself.
Hey,
Can you explain why we are adding ID of hires also in the denominator?
Anonymous
Wasn't that your question
"o I want to be able to calculate the hiring rate based on the two tables which would be count of ID in Hires table divided by count of ID's in the employee table. Is there a way that I can create a measure to calculate the hiring rate based on the ID's from the 2 tables? "
Anonymous Hey I did not check your output while typing that. I was replying for the other solution.
I'll check this out and let you know!
My mistake. If Employees is all-inclusive then you should not add it in the denominator.
PowerBSerThis one works. But the denominator is only count of employees
Anonymous its diff to follow what you are referring to, can you please tag the appropriate people in your post? Also the denominator can be anything you want. I sent you a simple way to write the formula you can change it to what you want.
ya ok. thank you! Anonymous