Target Mesasure

[Anonymous]

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

[parry2k]

@Anonymous sorry your question is not very clear, can you provide more details with sample data and expected output. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

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]

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

[Anonymous]

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

[Anonymous]

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