KPI Limit = Value of Percentage

[jcampbell]

I'm having trouble trying to get the right limit set on conditional coloring on a KPI. My KPI is calculating the number of errors from the previous month using the following measure:

Sum({<[Month]={'$(vMonthPrevious)'}>}[Errors])

Now I wanted to add a limit to color the value Red if the percentage of errors is greater than 0.001 (e.g. 1/1000). The following measure returns the percentage but now I need to color based on that percentage being greater than 0.001:

=Num(Sum({<[Month]={'$(vMonthPrevious)'}>}[Errors])) / Num(Sum({<[Month]={'$(vMonthPrevious)'}>}[Transactions]))

Any help would be appreciated. Thanks!

[brunobertels]

Hi

In your KPI object you should have this for conditionnal color

just Try to put 0.001

[jcampbell]

It didn't seem to work. I actually made it 0.03 to try to get it to employ the conditional formatting - but no success. See attached.