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

[Berl21]

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.

[john_mulqueen]

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