Forum Discussion
Solved
Create Measure on chart
I have the following structure. 2 tables - Hires and Employee connected by a key. I would like to create a ratio field = Count of hires / Count of Employee. I am a Qlikview user moving to Po...
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
