Paginated Report

Power BI Software & Tools
21

Hi @wendyzhang! We noticed that your inquiry was left unsolved for quite some time now.

We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!

1 Like
22

Thank you for all your help and suggestions.

We have decided to create the report in Power BI to resolve the issue in calculation.

Wendy

1 Like
23

Hi @WendyZhang,

The paginated format requires the query change so that all detail data is pre-aggregated, which then allows the scope-specific aggregations to work as required. I’m glad you were able to pursue a multi-dimensional solution.

John

1 Like
24

Absolutely. We’ve figured the query needs to be optimized first.

Thank you John.

Wendy