Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
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 |
User | Count |
---|---|
20 | |
14 | |
11 | |
8 | |
6 |
User | Count |
---|---|
23 | |
23 | |
20 | |
15 | |
10 |