Forum Discussion
Measure based on 2 tables
Hey, Suppose I have a table called Hires as: ID NAME 1 A 2 B 3 C . . And another Table Called Employees ID Country 1 X 2 Y 3 Z So I want to b...
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)
Anonymous if this is accepted solution, could you mark it as one.
Hey I am getting all 1 with this. The other solution gives me the correct answer. Thank You!