Forum Discussion
Dynamic segmentation based on average sales with in added column
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.