Employment conversion rate measure calculation

Hi,

So the numerator has to be the count of all rows that have 20 in the stat column and the denominator has to be all rows that have 11 in the stat column.  Am i correct?  Share the link from where i can download your PBI file.

Hi Ashish_Mathur ,

Thank you for your comment. No I have some more considerations in calculation of this conversion rate. I want to find the rate that 11 (Interviewed applicant) turned to 20 (Employed). So there should be an 20 for counted 11 (on the same ref ID/job position) and also the 11 time stamp should be before the time stamp of related (on the same ref ID) 20 .
in the sample data there are two 11 that I dont want to count as below:

You can find the whole data here, but lets start working with the sample data.

Hi v-xulin-mstf ,

Thank you so much for your time and effort to find the solution. Its woorking perfectly.

Cheers,

Hiv-xulin-mstf 

Thanks for your response. I used your suggested solution but I noticed that its not working properly!! as we manage part of the filtering in a column which make it so undynamic!
I believe we have to manage the whole filtering and calculation in measure level and not in the columns as I want to show these conversion rates in bar chart (conversion rate per month).
so it calculate all the record with stat 20 and devide by all record with stat 11 and column=1. so our measure fail to filter stat 11s that have the same reference_ID (position).
It would be great if you can have another look on it

Cheers,