Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I am new to Power BI and having trouble creating a new measure called 'Conversion'
My data is as follows in one column;
Application
Application
Admit
Admit
Admit
Offer
Accept
Accept
Application
Offer
Admit
Application
I would like to divide the count of Accept by the count Application.
I think it is something like the following, but can't get it to work as it is not numeric data but rather count of values.
Measure = DIVIDE( SUM([Number of Acceptances]) / SUM([Number of Applications]) )
Thanks
RH
Solved! Go to Solution.
Hi @Rebecca_Hadad,
not sure I follow, you say you want the ratio of "Accept" and "Admit" over total applications. You have two "Accept" and four "Admit" in your example, i.e. 50%. Anyway, a simpler formula to accomplish this:
Conversion = CALCULATE(COUNTROWS(Applications), Applications[Status] = "Accept" || Applications[Status] = "Admit") / COUNTROWS(Applications)
Hi @Rebecca_Hadad,
You may download my solution from here.
Hope this helps.
Hi @Rebecca_Hadad,
You can create a measure below:
Measure = DIVIDE(CALCULATE(COUNT(Table1[Column1]),FILTER(ALL(Table1[Column1]),'Table1'[Column1]="Accept")),CALCULATE(COUNT(Table1[Column1]),FILTER(ALL(Table1[Column1]),'Table1'[Column1]="Application")))
Best Regards,
Qiuyun Yu
Hi,
Thank you for the reponse.
Also, if I want to treat every data line (every measure as an application), even those that are offered and admit, then the true acceptance conversion would be 25% (3 (2 x accept plus 1 Admit) divided by 12 Applications).
How then, could I modify the measure calc to include each measure as an application.
Thanks
Hi @Rebecca_Hadad,
not sure I follow, you say you want the ratio of "Accept" and "Admit" over total applications. You have two "Accept" and four "Admit" in your example, i.e. 50%. Anyway, a simpler formula to accomplish this:
Conversion = CALCULATE(COUNTROWS(Applications), Applications[Status] = "Accept" || Applications[Status] = "Admit") / COUNTROWS(Applications)
Hi Erik,
Apologies, perhaps I didn't make myslef clear. But Any row in the data is an application, i.e. offer or admit should also be counted as an application its just that they are at a different stage of the application process.
Thankyou for the simplified formula.
Hi @Rebecca_Hadad,
From your description, it seems the issue is solved now, right?
Best Regards,
Qiuyun Yu