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))
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
Community Champion
Community ChampionTry:
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))