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,
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
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |