Forum Discussion

Jon3sy's avatar
Jon3sy
Helper I
4 years ago
Solved

KPI Scorecard Weighted Formulas

How do I write DAX code for the calculated live weighted score from the following data

For this 1 x KPI:

the KPI Scorecard weighting is 10% of the total Scorecard

# of records evaluated = 8, # or those 8 records that achieved the KPI = 6

Scorecard Target KPI value is in a range of 88-92% - so for the above records evaluated the score to date = 6/8 = 75%

So what is the formula for determining the live score of the 75% vs 88-92%, etc

The performance band is a 5 band range which I have created a measure for (the result above is Poor = 0 value, based on the below formula - which is the correct value) 

if([PM05 KPI Total]<.83, 0,
    if(AND([PM05 KPI Total]>=.83, [PM05 KPI Total]<.88), 1,
    if(AND([PM05 KPI Total]>=.88, [PM05 KPI Total]<=.92), 2,
    if(AND([PM05 KPI Total]>.92, [PM05 KPI Total]<.98), 3, 4))
))
 
Thanks in advance
Need Help
  • Jon3sy's avatar
    Jon3sy
    4 years ago

    Thank you for responding - I have worked it out now

     

    The formula for the weighted live score is PM05 KPI Band Score * the scorecard weighting

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Jon3sy , Not very clear

    Assume you have a measure PM05 KPI Total, and you can count it .83 for success

     

    then

    countx(Table, if([PM05 KPI Total]>.83 ,1 0)

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Jon3sy's avatar
      Jon3sy
      Helper I
      4 years ago

      Thank you for responding - I have worked it out now

       

      The formula for the weighted live score is PM05 KPI Band Score * the scorecard weighting