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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Heena_9980400
Helper IV
Helper IV

How to add total of 2 metrics tables and show in another table in power bi reports

Hi Experts,

I have a requirement like need to add the total column-wise from the registration table with the FastTrack table and need to show the total on the next page.

Heena_9980400_0-1664214818737.png

For example- u can see 0 days in both tables, I want a total of registration o days + the addition of 0 days of fast track and need to show that total on the below page

Heena_9980400_1-1664214942053.png

 

BR,

Kousar

 

1 REPLY 1
Anonymous
Not applicable

Hi @Heena_9980400 ,

 

Is your visual a matrix or a table or something else?

Do you want to calculate the total of 0 days for the registration table and 0 days for the FastTrack table? If yes, then according to the example data (0+3=3), the 0 days column of the second graph should be displayed as 3 not 2. If not, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

 

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

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.