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

Heena_9980400 — Mon, 26 Sep 2022 17:58:03 GMT

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.

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

BR,

Kousar

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

Anonymous — Tue, 27 Sep 2022 09:57:45 GMT

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.

topic Re: How to add total of 2 metrics tables and show in another table in power bi reports in DAX Commands and Tips

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

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