cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors