Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Target Mesasure

How can I create a target measure for "less than X"?   I need this to enter into the KPI Visual so that scores below 2 are considered achieved.   Thanks
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have a column of numbers called 'Total Errors'. In the KPI Visual above, I want to enter a 'Target Goal' so that the average score below 2.00 is achieving the KPI. I just don't know how to enter 'less than 2' as the target.

 

Thanks

 
  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous sorry there is no visual, and can you share data. and some screen shot what you are trying to achieve.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hopefully this helps. Basically, below 2 is goal achieved. Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous,

        It sounds like a common calculation with filter, you can write measure with calculator and aggregate(sum, average, max, min...) function to achieve your requirement:

        measure =
CALCULATE (
    AVERAGE ( Table[column] ),
    FILTER ( ALLSELECTED ( Table ), [Total Errors] < 2 )
)

        Notice: you can replace 'average' to other aggregate functions to achieve different summary methods.

        Regards,

        Xiaoxin Sheng