topic Re: KPI Limit = Value of Percentage in App Development

KPI Limit = Value of Percentage

jcampbell — Tue, 09 Feb 2016 19:58:05 GMT

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

brunobertels — Wed, 10 Feb 2016 10:24:04 GMT

In your KPI object you should have this for conditionnal color

just Try to put 0.001

Re: KPI Limit = Value of Percentage

jcampbell — Fri, 12 Feb 2016 14:23:02 GMT

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.