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))