cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## How to calculate the conversion rate using 02 columns

Hi,

I am facing a challenge that is to calculate the conversion rate using 02 fields in the same table.

My Table Structure is like this:

TITTLE | CATEGORY | STAGE

OP1 | NEW LOGO | LEAD

OP2 | NEW LOGO | LEAD

OP3 | NEW LOGO | MQL

OP6 | BASE | MQL

OP7|BASE | SQL

etc ...

I've tryed the following formula:

CONVESION=
CALCULATE(COUNTROWS(B_OP_FULL),DISTINCTCOUNT(B_OP_FULL[STAGE]))
/ CALCULATE(COUNTROWS(B_OP_FULL),DISTINCTCOUNT(B_OP_FULL[CATEGORY]) )

But I'm receiving an error.

My problem is that I need to count rows in my stages and divide by total of the category.

The result that I expect using the sample gived is:

NEW LOGO | LEADS | (2/3) = 67%

NEW LOGO | MQL | (1/3) = 33%

BASE | LEAD | (2/4) = 50%

BASE | MQL | (1/4) = 25%

BASE | SQL |  (1/4) = 25%

Thank very much!

1 ACCEPTED SOLUTION
Super User

@pforchito I created few measure for you to understand how it works but you can always put all these in one measure:

``````Count Rows = COUNTROWS ( YourTable )

Count Category = CALCULATE ( [Count Rows], REMOVEFILTERS ( YourTable[Stage] ) )

% = DIVIDE ( [Count Rows], [Count Category] ) ``````

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Super User

@pforchito I created few measure for you to understand how it works but you can always put all these in one measure:

``````Count Rows = COUNTROWS ( YourTable )

Count Category = CALCULATE ( [Count Rows], REMOVEFILTERS ( YourTable[Stage] ) )

% = DIVIDE ( [Count Rows], [Count Category] ) ``````

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.