Forum Discussion
Add TOTAL from different tables
Hi,
I created this matrix in Power BI Desktop that contains the number of a KPI for each sales office. Each column comes from a different table (source). I created a new table in order to have relationships between, since some tables doesn't have the same countries. That table have the name of all Sales Offices (countries) that relates to the other tables and are related with the "Sales Office" field, and that table is the one that appears in the rows.
I do have a total for each column. But what I need to do is create a Total that sums the total for each sales office (country), the typical total that appears in the right end. For instance , in the first row, I need to sum the following numbers: 0,0,38,21,0,41,117,23,0,0 and so on.
How could I do that?
Thanks in advance!
1 Reply
You would create a measure that would sum all of those different things up. If they are columns:
SUM('Table'[Column]) + SUM('Table1'[Column1]) + ...
Then just put that measure in your matrix perhaps.
Really hard to say because no idea really how your matrix is laid out or your source data, etc.
