Forum Discussion
Anonymous
6 years agoNot applicable
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 re...
Greg_Deckler
6 years agoCommunity Champion
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.