Forum Discussion
Dynamic Segment Flow DAX measure
Hey all, I've been struggling a lot today, trying to get something to work. What I'm trying to build is a dynamic segment migration report. For every week, every customer is put into one of 5 se...
I got so far as to get one row for every UUID with each destination and source, I just can't figure out how to group this by every combination of segments 😞 (and no, just changing the loyaltyID to a count does not work, the measure I use to create the segment source data does not play nice with that.
Here's the measure for reference:
_Segment in comparison period =
VAR SelectedWeekInPast = SELECTEDVALUE(ProgramWeekSelector[ProgramWeekCombination])
RETURN
CALCULATE(
MAX('rfm LoyaltySegmentation'[SegmentName]),
ALL('rfm LoyaltySegmentation'[SegmentName]),
'rfm LoyaltySegmentation'[ProgramWeekCombination] = SelectedWeekInPast
)