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 any...
Need Help
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)

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

      Anonymous Try this...

      % Target Revenue Surplus =
DIVIDE (
    CALCULATE (
        SUM ( Facts[Vl_Suplementado] ) * 100;
        Facts[OrigemRecurso_DS] = "Surplus Financial"
    );
    DIVIDE ( SUM ( Facts[Vl_ReceitaPrevista] ); 100; 0 );
    0
)
      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Sean

        works however when the numeric value is represented is bringing more decimal places

         

        with a filter

         

        without filter