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:



      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!