Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Gealnath
New Member

Total Lines, based on tables

Hey!

 

I have 5 pages in my report, all using a table (a visual object) with similar layout, only different input from the raw data. All these tables have one thing in common, they have a total line on the last column. Is there any way to capture this total line so I can mulitply them into a new table? I can't use the raw data it self, cause it has to many lines. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi,@Gealnath .I am glad to help you.
As I understand your description, you are trying to summarize the final aggregated result (Total value) of a visual in each page into the same page for presentation.
Unfortunately, the Total value in a visual cannot be passed across pages. You need to simulate the calculation environment in visual and write a measure /calculate column that has the same effect ,summarize them in a table for display.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-sgandrathi
Community Support
Community Support

Hi @Gealnath 

Has your issue been resolved?If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

Hi @Gealnath,

 

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

 

Hi @Gealnath,

 

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

 

Thank you.

Anonymous
Not applicable

Hi,@Gealnath .I am glad to help you.
As I understand your description, you are trying to summarize the final aggregated result (Total value) of a visual in each page into the same page for presentation.
Unfortunately, the Total value in a visual cannot be passed across pages. You need to simulate the calculation environment in visual and write a measure /calculate column that has the same effect ,summarize them in a table for display.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.