Forum Discussion
Count IF less than for each category
Hi, I have a set of data that is being used to track reviews meeting a 30 day deadline: Asessor Days since last review Asessor 1 20 Asessor 1 34 Asessor 1 100 Asessor 1 5 ...
Try:
Less than 30 by row = CALCULATE(COUNT('Table'[Asessor]), FILTER('Table', 'Table'[Days since last review] < 30))Over 30 days = CALCULATE(COUNT('Table'[Asessor]), FILTER('Table', 'Table'[Days since last review] > 30))
PaulDBrown
Community Champion
Community ChampionThe following measure will return a count fo 1 for every row where the days <30:
Less than = CALCULATE(COUNT('Table'[Asessor]), FILTER('Table', SUM('Table'[Days since last review]) < 30))
However, as you see this works for non - aggregated values; for aggregated values there are no "Asessor"s with a vlue under 30. Also, how do you wish to calculated the total?
Hi!
Thank you for the swift reply.
Apologies i may have worded that poorly, i need to count how many of the asessors learners havent had a review in over 30 days, asessor 1 in this example has 2 learners over 30 days and asessor 2 has 1 over.
| Asessor | Days since last review | Asessor | # over 30 | |
| Asessor 1 | 20 | asessor 1 | 2 | |
| Asessor 1 | 34 | Asessor 2 | 1 | |
| Asessor 1 | 100 | |||
| Asessor 1 | 5 | |||
| Asessor 2 | 19 | |||
| Asessor 2 | 10 | |||
| Asessor 2 | 34 | |||
| Asessor 2 | 28 |
- PaulDBrown
Try:
Less than 30 by row = CALCULATE(COUNT('Table'[Asessor]), FILTER('Table', 'Table'[Days since last review] < 30))Over 30 days = CALCULATE(COUNT('Table'[Asessor]), FILTER('Table', 'Table'[Days since last review] > 30))