Power BI KPI Matrix Displaying Zero Target Value

Hi Anonymous 

When the divisor is zero, any increase or decrease percentage would be infinite, which is mathematically meaningless. I'm not in your situation so I'm not able to suggest which optional result can meet your need better when the target value is zero. It's up to you. 

You can create a measure like below and replace "whatever" with the value you want for the special case when target value is zero. 

rate =
DIVIDE (
    SUM ( 'tablename'[Current Value] ) - SUM ( 'tablename'[Target Value] ),
    SUM ( 'tablename'[Target Value] ),
    "whatever"
)

I put it in a table visual as below. 

There are many discussions about how to calculate growth percent when start value is 0. You can refer to below discussions or google a bit to get some ideas. 

calculation - What is the correct answer for percent change when the start amount is zero dollars $0? - Personal Finance & Money Stack Exchange

math - How to calculate percentage when old value is ZERO - Stack Overflow

How to get a percentage increase from a base of 0 in Excel - Quora

Best regards,

Jing

If this post helps, please Accept it as Solution to help other members find it.