Forum Discussion
Helper IIEmployment conversion rate measure calculation
Hi SadStatue,
I updated the demo, please refer: Employment-conversion-rate-measure-calculation
Here is the output:
Best Regards,
Link
Super UserSadStatue , Try a measure like
divide(calculate(distinctcount(Table[Name]), filter(Table, Table[stat] = 20)),calculate(distinctcount(Table[Name]), filter(Table, Table[stat] = 11)))
Helper IIHi amitchandak
Thank you for your quick response.
No it wont work as u just simply filter just by stat while I have 2 more conditions (it is 2/6=0.33 which is not what I want)
1. Calculating number of applicant with stat 11 for the same positions(Reference ID) that sb get stat 20
2. Time stamp of records with stat 11 should be equal or before the time stamp of the records with stat 20 for that position (Reference ID)
I've amended the main post sample data and marked those records with sat of 11 that want to be calculated in my measure with X. As u see there are 2 records with stat of 11 which is not marked one of them is for C_a 127, as no one get stat 20 for this reference ID (position) and the other one is the last line record, and its not marked as its time stamp is after the time stamp of the record one to last (the one that have stat 20 for the same refrence ID)
You can also find the whole data and a larger sample data in the hyper link of the main post.
I hope I could shed some light on the issue by this extra description.
Cheers,