Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

The measures you want to segment have to evaluate only the rows with a price within the selected segments. Thus, assuming that SalesAmount is the original measure, you define the corresponding SalesRange measure that handles segmentation as follows:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
SalesRange :=
CALCULATE (
    [SalesAmount],
    FILTER (
        VALUES ( Sales[Price] ),
        COUNTROWS (
            FILTER (
                Ranges,
                Sales[Price] >= Ranges[Min Price]
                && Sales[Price] < Ranges[Max Price]
            )
        ) > 0
    )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hey Lewis, I can't say I follow. You're talking about sales amounts but I only have segment names. The segmentation has already been done. My question is about what comes after.