Forum Discussion

pmhoang94's avatar
pmhoang94
Icon for Helper I rankHelper I
9 years ago

Change "Infinity%" KPI

Hi all,

I want to change "Infinity%" text by other text or blank.

Can anyone help me?

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Perhaps you could create a measure to use as a target for this KPI:

     

    Target Non Blank = IF(ISBLANK(SUM(TableOfTargets[Target]));0;SUM(TableOfTargets[Target]))

    Then if target is not defined in TableOfTargets table the KPI would look like this:

     

    And yes, I know the Goal is not zero :-) But if everyone knows there are no zero-goals it's easy to understand there is no goal found in the data really.

     

    Cheers,

    Pawel