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

    KPI Limit = Value of Percentage

    Josh Campbell

      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!