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

Helper III

## DAX: write a measure that corrects conversion rate to a 100%

Hi,

I have the following issue:

A lead can generate 2 or more opportunities, or never convert. I want to compute the conversion rate of leads into opportunities but not take into account all the additional opportunities after the 1st one.

For instance, I have the following:

Lead A and C should generate a 100% CR, Lead B a 0%.

I am thinking there is a way to write an if statement in DAX, in the likes of if CR > 100%, then write 100%. But I am not sure exactly how and which functions to use.

Can anyone help out?

Thanks,

Pauline.

New Member

Might need some more details to give you a good answer, but I'm assuming you have something like this in a table

``````Distinct count =
CALCULATE ( DISTINCTCOUNT ( 'Table'[Lead] ), 'Table'[Status] = "Converted" )``````

 Lead Opportunity Status A A_1 Converted A A_2 Converted A A_3 Converted A A_4 Converted A A_5 Converted A A_6 Converted A A_7 Converted A A_8 Converted A A_9 Converted A A_10 Converted A A_11 Converted A A_12 Converted A A_13 Converted A A_14 Converted A A_15 Converted A A_16 Converted A A_17 Converted A A_18 Converted A A_19 Converted A A_20 Converted A A_21 Converted A A_22 Converted A A_23 Converted A A_24 Converted A A_25 Converted A A_26 Converted A A_27 Converted A A_28 Converted A A_29 Converted A A_30 Converted A A_31 Converted A A_32 Converted A A_33 Converted A A_34 Converted B B_1 Not Converted C C_1 Converted

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.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors