Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
Solved! Go to Solution.
for except this error you should use ROUND
AVG =
var _sales=Round([Sales],2)
var _pounds = Round([Pounds],2)
var _result = CALCULATE(IF(
OR(_sales = 0, _pounds = 0),0,DIVIDE(_sales,_pounds ))
return _result
Why the ABS?
if you want to check if the measure is 0 (not blank), use [Sales] == 0
Proud to be a Super User!
Paul on Linkedin.
for except this error you should use ROUND
AVG =
var _sales=Round([Sales],2)
var _pounds = Round([Pounds],2)
var _result = CALCULATE(IF(
OR(_sales = 0, _pounds = 0),0,DIVIDE(_sales,_pounds ))
return _result
Thanks for the solution! I solved it
please mark this topic as solved 🙂
hello
it is mean what in [pounds] you have number 2.66E-14
another words it is not 0 it is very small number
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
84 | |
84 | |
66 | |
63 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |