Dynamic segmentation based on average sales with in added column

[kapucino]

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]

)

)

[kapucino]

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.