Calculate scores with Weights

[sofias]

Hello everyone,

I need some help. I need to build a report with several KPI's, to evaluate performance by the partner.
Each of the KPI's have different thresholds, that signal if the performance of that KPI is good or bad. Also, each of the KPI's have different weights for the final calculation of the overall scoring of each partner.

Let me give you an example:

 

Here  I am doing the calculation of the score of that KPI, according to its threshold. The weight will be used for the final score of the partner, for that KPI, as follows:

Can you please help me understand how can I translate this into DAX? 

Thank you!

[v-chuncz-msft · Accepted solution]

@sofias,

You may use DAX below.

Measure =
SUMX (
    Table1,
    MIN (
        MAX (
            DIVIDE ( Table1[Sample Score] - Table1[Worst], Table1[Best] - Table1[Worst] ),
            0
        ),
        1
    )
        * Table1[Weight]
)