Forum Discussion
Report Builder - Need IFERROR Equivalent
Using MS Report Builder, I have a calculated field in the report where part of the equation is rendering a 0 and as a result the whole calculation is getting set to 0. However, I want to include an ...
The built in DIVIDE function has the option to specify an alternative result (i.e what happens if there is a 0 in the denominator) - https://learn.microsoft.com/en-us/dax/divide-function-dax. Basically, you would be able to put 0 as the 3rd parameter
vicky_ I can't get it to work. This is supposed to work in the PowerBI MS Report Builder?