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

 

 

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

     

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    use the DIVIDE function instead of  "/"

  • 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