NaN Error

[Pinky0404]

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

[Smauro]

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]

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 · Accepted solution]

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