cancel
Showing results for
Did you mean:
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

Offer

Accept

Accept

Application

Offer

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
Established Member

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

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

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

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

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.
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

Established Member

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

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

Hope this helps.

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

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

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.