Paginated Reports DIV/0 Error

A draw back with Power BI is that the expression will still try to calculate a value even though the IIF asks it not to.

I believe the answer provided by Philip is for DAX in Power BI Dashbord reports i.e. Power BI Desktop. As I understand it, in your case, you are using Power BI Report Builder (SSRS for the old folks) to build a paginated report. 

Power BI Report Builder has no built in Divide function. However, you can create one.

1. With your report opened in Power BI Report Builder, right click on the dark grey area surronding your report and choose Report Properties from the context menu. This will display the Report Properties dialog box.
2. On the Report Properties dialog box, click the Code tab. This will display the Custom code textbox.
3. In the Custom code textbox, enter the following function declaration:

Public Function Divide(ByVal Numerator As Double, ByVal Denominator As Double, ByVal AltResult As Double) AS Double
If IsNothing(Denominator) Or Denominator = 0
Return AltResult
Else
Return Numerator/Denominator
End If
End Function 

Once this is created, you can call it in your Expression like this:

=IIf(Sum(Fields!ID_Last_4_Weeks_Difference_ECNs_.Value) = 0, "", 
code.Divide(Sum(Fields!ID_Last_4_Weeks_Difference_ECNs_.Value/4), 
Sum(Fields!ID_Last_4_Weeks_Previous_Year_ECNs_.Value/4), 0))

Notes:

1. When calling the function, you must put "code" before your function name.
2. The function call is saying, if zero is the Denominator, return zero as the result. You can supply any alternative number you want (e.g. -1).
3. I am assuming that the issue is that the second SUM in the division (the denominator) is causing the issue. Zero as the numerator should return zero.
4. Multiple functions can be created in the Custom code field. Just add the latest code to the top or bottom of the field.
5. This is not verified code, so anyone is welcome to improve it.

I hope this helps someone.

You can upload the file to some cloud storage platform like OneDrive or Google Drive and share the link here, so that we can download it. Remove sensitive info before sharing.

Additionally, I found some topics about this same error related to SSRS, maybe they can help.

https://stackoverflow.com/questions/21552118/ssrs-expression-the-value-expression-for-textbox-has-scope-parameter-that-is-in

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/708b9ece-b631-4a11-90b1-f867c943040f/report-builder-the-value-expression-has-a-scope-parameter-that-is-not-valid-for-an-aggregate?forum=sqlreportingservices

Expression examples:

https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-expression-examples#DecisionFunctions