cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Pinky0404 Member
Member

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

Sample 2018.PNG

 

 

Thanks in Advance !!

Pinky

1 ACCEPTED SOLUTION

Accepted Solutions
v-yulgu-msft Super Contributor
Super Contributor

Re: NaN Error

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Smauro Regular Visitor
Regular Visitor

Re: NaN Error

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! Smiley Happy

Pinky0404 Member
Member

Re: NaN Error

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

Re: NaN Error

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 106 members 1,604 guests
Please welcome our newest community members: