Forum Discussion

SaaM's avatar
SaaM
Helper II
4 years ago
Solved

Segment values

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

 

Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    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))

     

     

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    SaaM , Create a new column

     

    Switch(True(),

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

    " > 500 "

    )

    • SaaM's avatar
      SaaM
      Helper II
      4 years ago

      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's avatar
        amitchandak
        Super User
        4 years ago

        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))

         

         

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    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.