Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Fix blank values and infinite

I have some graphics that as the filter made the values of these graphs is blank or infinite, and according to the business rule that can happen but I need to make when this happens does not show anything, no value should be displayed, is possible to do that?

 

Need Help

6 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Anonymous for all Measures that give you BLANK() in Cards do the following...

     

    = IF ( ISBLANK ( [Expression]), 0, [Expression] )

     

     

     

    • Sean's avatar
      Sean
      Icon for Community Champion rankCommunity Champion
      10 years ago

      Anonymous infinity happens when you divide by zero so instead of / use the DIVIDE function

       

      = DIVIDE( [Numerator], [Denominator], 0)

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Sean

        tried to use the DIVIDE function in my measure however is not working

         

        % Target Revenue Surplus = (DIVIDE (CALCULATE (SUM (Facts [Vl_Suplementado]) * 100; Facts [OrigemRecurso_DS] = "Surplus Financial") / sum (Facts [Vl_ReceitaPrevista])) / 100); 0)