Forum Discussion

Pinky0404's avatar
Pinky0404
Helper III
8 years ago
Solved

NaN Error

Hi All,

 

I  have two columns , "Total Queries" & "Other blocked" and when i try to divide Other blocked / Total Queries is throwing NaN value when both columns has value 0. Hence unable to calculate the percentage for the same. Could anyone please help me with the NaN error .

 

Attaching sample where %  column should  actually result in 0.18 value  instead of  0.71

 

 

Thanks in Advance !!

Pinky

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Pinky0404,

     

    Glad to hear that you have resolved your problem. Would you please kindly mark your sharing solution as an answer so that it can benefit more users?

     

    Thanks,

    Yuliana Gu

3 Replies

  • Smauro's avatar
    Smauro
    Solution Sage
    8 years ago

    Hey there Pinky0404!

    You would probably be best with using the [b]DIVIDE[/b] function ( https://msdn.microsoft.com/en-us/library/jj677276.aspx ) where you could right something like:

    P% = DIVIDE([Other Blocked], [Total Queries], 0)

    Where you'd see a 0 in case [Total Queries] = 0. You simply then format the measure as a percentage in Modeling.

     

    More, I see that you have [Other blocked] as a decimal, which I guess is redundant. I'd change it to whole number, you never know if DAX has any problems with dividing different types.

     

    Hope this helps! :)

    • Pinky0404's avatar
      Pinky0404
      Helper III
      8 years ago

      Thanks for your response. I found an answer. i was directly dividing the columns  which was giving  the total % , rather calculating as sum(other blocked)/sum(total queries).

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        8 years ago

        Hi Pinky0404,

         

        Glad to hear that you have resolved your problem. Would you please kindly mark your sharing solution as an answer so that it can benefit more users?

         

        Thanks,

        Yuliana Gu