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. ...
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
Impactful Individual
Impactful IndividualI 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
Hi Yukik,
It seems that the secons argument is not valid entry in this function: