Forum Discussion

kapucino's avatar
kapucino
Frequent Visitor
6 years ago

Dynamic segmentation based on average sales with in added column

 

Customer segmentation is done based on a daily sales (TW) with calculated column. It  works fine for segmentation on each separate sales. Looking for a measure to  segment Customers based on yearly average sales ?

 

Current measure and tables:

 

TWSegment = CALCULATE(

Values (TW_segment[Class]);

Filter(

TW_segment;

baza[TW]>= TW_segment[Min] &&

baza[TW]< TW_segment[Max]

)

)

 

1 Reply

  • kapucino's avatar
    kapucino
    Frequent Visitor
    6 years ago

    I managed to calculate dynamic average TW sales with complex DAX similar to this one. But this case is a bit trickier.

     

    What is required is dynamic segmentation data in added column. Goal  is for example:

     

    - to be able to count number od customers within segment - where segment is calculated dynamically based on average sales ( TW) per customer for filtered/  selected period ( month/ year).

    - to be able to count number od Countries within segment -where segment is calculated dynamically based on average sales ( TW) per customer for filtered/  selected period ( month/ year).

     

    Scenario is therefore:

    - Year/month filter is selected,

    - Avarage TW for selected period is calculated,

    - Based on average TW Segment group should be  added column,

    - Analytics based on this dynamic information in added column is calculated.

     

    Any hint how this can be accomplished is appreciated.