Forum Discussion
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
Hopefully this helps. Basically, below 2 is goal achieved. Thanks
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