2 Replies Latest reply: Feb 12, 2016 9:23 AM by Josh Campbell

# KPI Limit = Value of Percentage

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!

• ###### Re: KPI Limit = Value of Percentage

Hi

In your KPI object you should have this for conditionnal color

just Try to put 0.001

• ###### Re: KPI Limit = Value of Percentage

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.