Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Measure to Count items in a defined range

Hi there, I have a simpe measure calculating the % completion in a matrix table, like this: Measure: I would need now a measure to count how many activities is a range of %Completion. ...
Need Help
YukiK's avatar
YukiK
Impactful Individual
3 years ago

Measure like this one should work:

 

YOURMEASURE =

SWITCH( TRUE, 

    AND([%Completion] >= 0.01, [%Completion]< 0.30 ), 0,

    AND([%Completion] >= 0.30, [%Completion]< 0.60 ), 4,

    etc

)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi YukiK, thanks for replying!

    Actually I need a measure to make the count of activities based on the range of %. This number will float over the time.. the numbers I showed above are one example based on my current table. Like in in the future, I can have 30 activities between 30% and 60% comletion...

    • YukiK's avatar
      YukiK
      Impactful Individual
      3 years ago

      I see. You can do something like this:

      0% ~ 5% = 
CALCULATE(
    COUNTROWS(your table),
    FILTER( 
        ALL(your table),
        [%Completion] >= 0,
        [%Completion] <= 0.05
    )
)

       

      This should be a good starting point at least!

       

      Please consider giving it a thumbs up and accept as a solution if this was helpful

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Yukik,

        It seems that the secons argument is not valid entry in this function: