Forum Discussion
farha
10 years agoNew Member
how to combine visualization from different reports to create one visualization.
Hi am new to BI Desktop, kindly need help. i have generated two visualization in tabular form (lets say visual A and visual B). From each visualization table i have sum value (sum A from visualization A and sum B from visualization B) . Now what i need is to combine the some values from the two visualization table and create another visualization (visualization C).
i.e inputs to visualization C will be sum A and Sum B (sum A+ sum B).
1 Reply
- WillT
Community Admin
Hi! You'll need to create a calculated measure to do this, it's difficult to say exactly what the syntax should be but simply adding the two values together might be enough. Something like: TotalSum = [Column A] + [Column B] If you put that in a 3rd table, it'll be the aggregate across all the rows in table A and B. The DAX language that you use to create these calculations is really powerful, and learning it is important if you're going to master Power BI! There's a good introduction here: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-quickstart-learn-dax-basics/ and some great reference books as you progress: http://www.sqlbi.com/books/the-definitive-guide-to-dax/?utm_source=sqlbi&utm_medium=banner&utm_content=home&utm_campaign=daxguide HTH!