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

     

     

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