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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

rollup columns within one table

Hello,

I am attempting to recreate a a pretty simple dahboard that i built in excel, but am having difficulties in setting columns to roll up to different levels within the same table.  My dash is set up as such:  A sales person chooses their name from a drop down at the top.  They can then look at their sales results by product and compare them to the results of the total state and the total country.

here is an example:

dropsown: sales person

columns: sales person's results || total state results || total country results

rows: products

the total country column will remain static by product, but the state column will change states depending on where the sales person resides. 

To do this, i use sumifs function referencing hidden columns and set up like this: =sumifs(sales, state=filtered state, sales person=filtered sales person, product=product intable)

I have a data sheet on another page that compares the values in the hidden columns to the data sheet.

My problem is that I am not able to create a rollup column that is not affected by the visual level filters.  For example, If I filter to a sales person, my state column will reflect sales only from that sales person and not the whole state. 

I tried setting up a seperate summarized table and connect them, but that doesnt interact with my brand filters.

This is so simple in excel, but I'm stuck in PBI!  Thank you for helping!

 

1 REPLY 1
Anonymous
Not applicable

Hello,

 

Can you upload here a PBI file sample so I can understand better what you trying to achive?

 

I dont know if this helps, but there is also the "Edit Interactions" button where you can manage which filters should/should not affect your visuals.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors