Forum Discussion

New Member

5 years ago

Paginated Reports DIV/0 Error

Hello everyone , I'm new to power BI report builder and have been able to google most things. However I am stuck here. I use this expression and it works 99% of the time except when Fields!ID_La...

Icon for Community Support rank

Community Support

5 years ago

Have you solved this problem? If not, can you share some dummy data so that I can use it to find possible solutions? Thank you.

Regards,
Community Support Team _ Jing

quads08
New Member
5 years ago
v-jingzhang
No I am still stuck. How can I share the dummy data?
- v-jingzhang
  Community Support
  5 years ago
  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