Attached is a solution. I used a Case statement as well as IF logic here. As you can see, you could easily change the Case statement out for another IF THEN statement but it makes the calculation a bit messy. Nesting logic statements is something that can be very powerful in Tableau in many more ways than just KPIs as well.
Please let me know if the attached was helpful or not.
Lights -- KPI.twbx.zip 9.3 KB