Fix blank values and infinite

Question

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?&nbsp;

sean · Answer

Anonymous&nbsp;infinity happens when you divide by zero so instead of / use the DIVIDE function&nbsp;= DIVIDE( [Numerator], [Denominator], 0)&nbsp;

sean · Answer

Anonymous&nbsp;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
)

sean · Answer

Anonymous&nbsp;for all Measures that give you BLANK()&nbsp;in Cards do the following...&nbsp;= IF ( ISBLANK ( [Expression]), 0, [Expression] )&nbsp;&nbsp;&nbsp;

anonymous · Answer

Seantried to use the DIVIDE function in my measure however is not working&nbsp;% Target Revenue Surplus = (DIVIDE (CALCULATE (SUM (Facts [Vl_Suplementado]) * 100; Facts [OrigemRecurso_DS] = "Surplus Financial") / sum (Facts [Vl_ReceitaPrevista])) / 100); 0)

anonymous · Answer

Seanworks however when the numeric value is represented is bringing more decimal places&nbsp;with a filter&nbsp;without filter&nbsp;

Forum Discussion

Related content

Replace Values Null to Blank or Blank to Null

Blank values

Filter out the blank values

Replacing null values with blank

SLICERS -> blank value