Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Berl21
Helper III
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 generates 34 opportunities
Lead B generates 0 opportunities
Lead C generates 1 opportunity

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.



1 REPLY 1
john_mulqueen
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" )

 

 

LeadOpportunityStatus
AA_1Converted
AA_2Converted
AA_3Converted
AA_4Converted
AA_5Converted
AA_6Converted
AA_7Converted
AA_8Converted
AA_9Converted
AA_10Converted
AA_11Converted
AA_12Converted
AA_13Converted
AA_14Converted
AA_15Converted
AA_16Converted
AA_17Converted
AA_18Converted
AA_19Converted
AA_20Converted
AA_21Converted
AA_22Converted
AA_23Converted
AA_24Converted
AA_25Converted
AA_26Converted
AA_27Converted
AA_28Converted
AA_29Converted
AA_30Converted
AA_31Converted
AA_32Converted
AA_33Converted
AA_34Converted
BB_1Not Converted
CC_1Converted

Helpful resources

Announcements
Europe Fabric Conference

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 Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.