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

Ya, you can use the "Related()" DAX function in some ways to do calculations. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey, can you please  explain with an example.

 

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 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.