Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]
)
)
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |