Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Marc_Ponick
Regular Visitor

Sum Totals from visuals on separate pages with their own separate filters

Hi,

Working on a forecast model that has one page for each Director, and a total page for the VP that is the sum of the 4 director pages.

There is only 1 data set.

All Directors have identical filters available to them (15 in total), but can choose whatever they like to create their own custom view.

Slicers are not sync'd accross the report as the directors can choose to include or exclude whatever is relevant to themselves.

The Pages all have 1 Table visual with an identical product column and a $ column.

Eg: (Director 1)

Product  |  Value

Cars        | $50

Dogs      | $25

Cats        | $25

Total:       | $100

 

The directors choose their respective filters and their tables total:

Director 1 total = $100

Director 2 total = $150

Director 3 Total = $120

Director 4 Total = $180

 

The VP page will have an identical table visual but the $ column needs to be the sum of the 4 Directors individual totals. The VP page will not have filters, it's simply a summary of the other 4 table visuals on the other pages and should equal $550 using the above example.

How can I create a Sum of the four separate visuals? 

This is built in desktop and published to a premium workspace.

 

Thanks,

Marc

2 REPLIES 2

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors