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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Shwetabh147
Frequent Visitor

Merging summary tables

Hello everyone.

i have a customer dimension with store level data.

a product table with product information. 
sales table which has sales at product and customer key level.

now my customer table is connected to product via sales table.

customer key from cust dimension is connected to sales product is connected to sales through gtin

 

 

Now. We have to segment the stores in 4 segments based on rank of sales.

and at the same time when a user filters a segment , then sales should change at all the attributes for product . Like we have a table in report which shows cat wise sales. 
so if user clicks on 1 st segment then the data should filter accordingly.

 

Thanks for looking into problem

 

2 REPLIES 2
bhanu_gautam
Super User
Super User

@Shwetabh147 , For this first you can create a measure for total sales

Total Sales = SUM(SalesTable[SalesAmount])

 

Then, Create a measure for rank

 

Store Sales Rank =
RANKX(
ALL(CustomerDimension[CustomerKey]),
[Total Sales],
,
DESC,
DENSE
)

 

Create a custom column in Customer Dim table

 

Store Segment =
SWITCH(
TRUE(),
[Store Sales Rank] <= 25, "Segment 1",
[Store Sales Rank] <= 50, "Segment 2",
[Store Sales Rank] <= 75, "Segment 3",
"Segment 4"
)

 

Then you can create visuals using these measure and columns,I have taken general scenarios as you have not given sample data

 




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






I have the segments added . Problem is . There is a table where we need to showcase category level sales . Now category is in product dimension. Ask is when user selects segment, the categories should also filter for that segment.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.