cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rebecca_Hadad Frequent Visitor
Frequent Visitor

Need to Calculate conversion rates for the count of a measure

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

1 ACCEPTED SOLUTION

Accepted Solutions
erik_tarnvik Established Member
Established Member

Re: Need to Calculate conversion rates for the count of a measure

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)

 

6 REPLIES 6
Moderator v-qiuyu-msft
Moderator

Re: Need to Calculate conversion rates for the count of a measure

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")))

 

r1.PNGr2.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Rebecca_Hadad Frequent Visitor
Frequent Visitor

Re: Need to Calculate conversion rates for the count of a measure

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

erik_tarnvik Established Member
Established Member

Re: Need to Calculate conversion rates for the count of a measure

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)

 

Super User
Super User

Re: Need to Calculate conversion rates for the count of a measure

Hi @Rebecca_Hadad,

 

You may download my solution from here.

 

Hope this helps.

Rebecca_Hadad Frequent Visitor
Frequent Visitor

Re: Need to Calculate conversion rates for the count of a measure

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.

 

 

Highlighted
Moderator v-qiuyu-msft
Moderator

Re: Need to Calculate conversion rates for the count of a measure

Hi @Rebecca_Hadad,

 

From your description, it seems the issue is solved now, right? 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.