Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • PowerBSer's avatar
    PowerBSer
    8 years ago

    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's avatar
    Anonymous
    8 years ago

    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's avatar
Anonymous
Not applicable
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous if this is accepted solution, could you mark it as one.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hey I am getting all 1 with this. The other solution gives me the correct answer. Thank You!