cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
karlagb20 Regular Visitor
Regular Visitor

Create a table with all Totals from different matrix and sources

Hi,

 

I have row subtotals in each matrix and each has a different sources. Is there a way I can make a table to bring each row subtotal into one table? 

 

The row subtotals are added when I make the matrix visual there's an option to turn them on. I would like to move the Row subtotal (ex: APAC) to a new table in another sheet and then eventually add all of them up and make a "global" from each of the rows subtotals that i got from each sheet

 

 

Totak.PNGMatrix: Last row is the TOTAL that I want to move add to another tableTotal2.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Create a table with all Totals from different matrix and sources

@karlagb20 

 

You may try Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Create a table with all Totals from different matrix and sources

@karlagb20 

 

You may try Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 43 members 1,124 guests
Please welcome our newest community members: