Forum Discussion
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.
In the given example above, the outcome would be as per below:
0% to 5% -> 0 activities
6% to 30% -> 0 activites
31% to 60% -> 4 activities
61% to 90% -> 2 activities
> 90% -> 4 activities
Hope someone can help with that!
thanks!
5 Replies
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
)
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...
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
