Nan and Infinity In Divide function

[Anonymous]

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

[Anonymous]

use the DIVIDE function instead of  "/"

[BrettBailey]

This should be the solution!

[Anonymous · Accepted solution]

Hi @Anonymous 

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

[Anonymous]

It worked with the Divide. Thanks