Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
@Marc_Ponick , based on what I got RLS can help
RLS - Row Level security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
Hi, @amitchandak this has nothing to do with RLS. There are no view restrictions mentioned in my question.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
9 |
User | Count |
---|---|
28 | |
23 | |
12 | |
11 | |
10 |