Forum Discussion
Create Measure on chart
Hi eiprakash,
You could refer to below fomula:
Hiring Rate = CALCULATE(COUNT(Table1[EmpNo.Hires]))/CALCULATE(COUNT(Table2[EmpNo.Active]))
Result:
You can also download the PBIX file to have a view.
https://www.dropbox.com/s/nm5gdnymrb3ma2v/Create%20Measure%20on%20chart.pbix?dl=0
Regards,
Daniel He
Greatly appreciate your help !!Below would be the Mock up data. Table A and B are connected using the Key Cost Center. I would like to calculate Hiring rate as a measure.
Hiring Rate = Count of EmpNo.Hires (From TableA) / Count of EmpNo.Active(From TableB) = 3/5 (Answer)
Table A:
EmpNo. Hires CostCenter
2 234
3 235
4 236
Table B:
EmpNo. Active CostCenter
5 234
4 235
7 236
9 232
2 231
Anonymous check this out