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

Hey,

 

Can you explain why we are adding ID of hires also in the denominator?

PowerBSer's avatar
PowerBSer
Frequent Visitor
8 years ago

My mistake.  If Employees is all-inclusive then you should not add it in the denominator.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    PowerBSer Ok, i will check it out and let you know.

     

    Thank You!