Forum Discussion

blackhall8's avatar
blackhall8
Frequent Visitor
7 years ago
Solved

Lead Scoring - Dynamically add/subtract points based on interactions

I'm trying to create a lead scoring measure or a conditonal column based on specific interactions in my table. How would I go about dynamically adding/substracting points?    Lead Scoring Logic ...
Need Help
Tips and Tricks
Tutorial Requests
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi blackhall8 ,

     

    Unfortunatly I cannot find a way to get your exact same as your excepted result here. I made one sample here for your reference. Please check whether it is fine or not.

     

    Here I create a measure based on the filtered table Lead Scoring Logic.

     

    Taken = 
VAR sumsc =
    CALCULATE ( SUM ( 'Lead Scoring Logic'[Score (points)] ) )
RETURN
    IF (
        sumsc = MAX ( 'data table'[Score] ),
        CONCATENATEX ( 'Lead Scoring Logic', 'Lead Scoring Logic'[Interaction], "&" )
    )

     

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi blackhall8 ,

 

Unfortunatly I cannot find a way to get your exact same as your excepted result here. I made one sample here for your reference. Please check whether it is fine or not.

 

Here I create a measure based on the filtered table Lead Scoring Logic.

 

Taken = 
VAR sumsc =
    CALCULATE ( SUM ( 'Lead Scoring Logic'[Score (points)] ) )
RETURN
    IF (
        sumsc = MAX ( 'data table'[Score] ),
        CONCATENATEX ( 'Lead Scoring Logic', 'Lead Scoring Logic'[Interaction], "&" )
    )