Segment values

[SaaM]

Hi,

With this data I would like to create a segment for Distance runned that varies from 0 - 500 but I didn't figure out so far how to do this.

My objective is to have a filter that allow to keep all the runners who runs more than N kms in total.

Thanks in advance

Kind regards

Saam

[v-yalanwu-msft]

Hi, @SaaM ;

First you could create a "0-500" table as a slicer. then create a flag measure .

1.create a table 

slicer = GENERATESERIES(0,500,1)

2.create a flag measure.

flag =
VAR _perruned =
    CALCULATE ( SUM ( [Distance runned] ), ALLEXCEPT ( 'Table', 'Table'[Athlete] ) )
RETURN
    IF (
        _perruned <= MAX ( 'slicer'[Value] )
            && _perruned >= MIN ( 'slicer'[Value] ),
        1,
        0
    )

3.apply it into filter.

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@SaaM , Create a new column

Switch(True(),

[Distance runned] < 500, " 1- 500",

" > 500 "

)

[SaaM]

Actually I am trying to have something like this to filter the distance runned by each athlete

for example the athelte a runned once 200 kms and then 300 kms so he runned 500 kms in total.

[amitchandak · Accepted solution]

@SaaM , You will not be able to create a bucket using this(what if) . You can create a measure

example

measure =
VAR _max = MAXX(allselected('Whatif'),'Whatif' [value])
var _min = MinX(allselected('Whatif'),'Whatif' [value])

return
calculate(Sum(Table[ConsumptionCount]), filter(Table, Table[Distance runned]>=_min && Table[Distance runned]<=_max))