Fix blank values and infinite

[Anonymous]

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?

[Sean]

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

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

[Sean]

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

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

[Anonymous]

@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]

@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]

@Sean

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

with a filter

without filter

[Sean]

@Anonymous Try this... let me know if this works

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