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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Marc_Ponick
Frequent 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

Hi, @amitchandak this has nothing to do with RLS. There are no view restrictions mentioned in my question.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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