Forum Discussion
Report Builder Error
Hello, I have a calculated field in Power BI Desktop that I am trying to match in Power BI Report Builder and it is working for some categories but not for others, and I'm not sure either where I...
The DIVIDE function in DAX will check for 0 values on the denominator and will return a blank (which will then probably get filtered out) so you probably need to do the same thing in your report expressions.
But I would suggest just referencing the same measure in your paginated report, then you only have one place to maintain the logic.