Need to Calculate conversion rates for the count of a measure

[Rebecca_Hadad]

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

[Ashish_Mathur]

Hi @Rebecca_Hadad,

You may download my solution from here.

Hope this helps.

[v-qiuyu-msft]

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 

[Rebecca_Hadad]

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 · Accepted 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)

[Rebecca_Hadad]

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.

[v-qiuyu-msft]

Hi @Rebecca_Hadad,

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

Best Regards,
Qiuyun Yu