cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vitexo87 Member
Member

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

6 REPLIES 6
Sean Super Contributor
Super Contributor

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
Sean Super Contributor
Super Contributor

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)

 

vitexo87 Member
Member

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)

Sean Super Contributor
Super Contributor

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

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

Sean Super Contributor
Super Contributor

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
)

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 123 members 1,818 guests