Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 Re...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

It worked with the Divide. Thanks