Target Mesasure

Question

How can I create a target measure for "less than X"?&nbsp;I need this to enter into the KPI Visual so that scores below 2 are considered achieved.&nbsp;Thanks

parry2k · Answer

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 · Answer

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 · Answer

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

anonymous · Answer

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

anonymous · Answer

Hi&nbsp;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] &lt; 2 )
)

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

Forum Discussion

Target Mesasure

5 Replies

Related content

Targets/Goals best practice

Publishing into Target Warehouse using VS Code causing issues

Calculating Days late with specific target times

Target to date

Targets in clustered chart