cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

Nan and Infinity In Divide function

Hi,

I have a growth calulated measure but the values are coming as nan and Infinity

below is the sample data

The dax to calulate is

#YOYClientGrowth1 = ([#Sum_ActualRevenue] - [#Gross Revenue Prior Year])/([#Gross Revenue Prior Year])

Now I need to put condition in the "#YOYClientGrowth1" for blank and 0 values

Blank and Blank as 0
Current value and Previous Blank then 1
Current Blank and Previous value result -1

1 ACCEPTED SOLUTION

Accepted Solutions
Established Member

Re: Nan and Infinity In Divide function

Hi @KKottha

You are getting NAN and Infinity because you are dividing 0 by 0 and 747 by blank ( where blanks it considers as zero)..

You will have to change your formula.

or you can try creating 2 quick measures.

- 1st measure for subtraction SUM and Gross Revenue

- 2nd to divide the above measure with Gross Revenue.

Add in table to get somehting like this.

Let me know if this helps .

Thanks,

Tejaswi

3 REPLIES 3
Established Member

Re: Nan and Infinity In Divide function

Hi @KKottha

You are getting NAN and Infinity because you are dividing 0 by 0 and 747 by blank ( where blanks it considers as zero)..

You will have to change your formula.

or you can try creating 2 quick measures.

- 1st measure for subtraction SUM and Gross Revenue

- 2nd to divide the above measure with Gross Revenue.

Add in table to get somehting like this.

Let me know if this helps .

Thanks,

Tejaswi

Super User

Re: Nan and Infinity In Divide function

use the DIVIDE function instead of  "/"

Frequent Visitor

Re: Nan and Infinity In Divide function

It worked with the Divide. Thanks

Announcements

Power BI Super User, Greg Deckler, explains

Power Platform Summit North America

Register by September 5 to save \$200

Back to School Contest

Engage and empower students with Power BI!

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 44 members 1,023 guests
Recent signins: