Forum Discussion
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 PowerBI. In Qlikview i was able to create these expressions in chart or text box. I would like to understand how it is being done in PowerBI
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
6 Replies
Hi,
Can you give some sample mocked-up data of your tables...and the key name using which they are connected
Hi eiprakash,
Could you mean show the formula in the visual? If so, I am afraid you could not achieve this feature currently, but you could add a text box beside the visual:
If I misunderstand you, please let me know as soon as possible.
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
