Lead scoring model

Hi Alessandro-laba ,

I create a simple example. Is this something like what you want?

You can create columns or measures like so:

Columns:

Custom Score = 
DIVIDE (
    'Ranking of best and worst states for retirement'[Affordability] 
    + 'Ranking of best and worst states for retirement'[Crime] 
    + 'Ranking of best and worst states for retirement'[Culture] 
    + 'Ranking of best and worst states for retirement'[Weather] 
    + 'Ranking of best and worst states for retirement'[Wellness]
    ,
    5
)

Custom Rank = 
RANKX (
    'Ranking of best and worst states for retirement',
    'Ranking of best and worst states for retirement'[Custom Score],
    ,
    DESC,
    DENSE
)

Or measures:

Custom Score Measure = 
DIVIDE (
    MAX('Ranking of best and worst states for retirement'[Affordability] )
    + MAX( 'Ranking of best and worst states for retirement'[Crime] )
    + MAX( 'Ranking of best and worst states for retirement'[Culture] )
    + MAX( 'Ranking of best and worst states for retirement'[Weather] )
    + MAX( 'Ranking of best and worst states for retirement'[Wellness] )
    ,
    5
) 

Custom Rank Measure = 
RANKX (
    ALL('Ranking of best and worst states for retirement'),
    [Custom Score Measure],
    ,
    DESC,
    DENSE
)

You can get details in the attached PBIX file.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.