Reply
Member
Posts: 336
Registered: ‎03-17-2016

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?

 

Untitled.png

Super User
Posts: 2,146
Registered: ‎08-11-2015

Re: Fix blank values and infinite

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

 

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

 

 

 

Highlighted
Super User
Posts: 2,146
Registered: ‎08-11-2015

Re: Fix blank values and infinite

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

 

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

 

Member
Posts: 336
Registered: ‎03-17-2016

Re: Fix blank values and infinite

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

Super User
Posts: 2,146
Registered: ‎08-11-2015

Re: Fix blank values and infinite

@vitexo87 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
)
Member
Posts: 336
Registered: ‎03-17-2016

Re: Fix blank values and infinite

@Sean

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

 

with a filter

Untitled.png

 

without filter

 

Untitled1.png

Super User
Posts: 2,146
Registered: ‎08-11-2015

Re: Fix blank values and infinite

@vitexo87 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
)