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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Parent Data Filters/Roll-up

Is there an easier way to roll-up data when filtering down to more specific data points? For instance, if I choose a store in my report, I would like to see sales for that store but then the parent category's sales as, say, the region, then division, then chain. This way I can identify how a product or store is performing as compared to it's "peers." The only way I could think to do this now is to create additional data points in my data model to show what those totals are for each child class but this could obviously explode my data size.
Status: Needs Votes
Comments
fbcideas_migusr
New Member
Status changed to: Needs Votes