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

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