Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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! 🙂
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).
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |