Forum Discussion

Shwetabh147's avatar
Shwetabh147
Frequent Visitor
2 years ago

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 ...
bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

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

 

  • Shwetabh147's avatar
    Shwetabh147
    Frequent Visitor
    2 years ago

    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.