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))
amitchandak
Super User
Super UserAnonymous , Try like
Calculate ( Count ('Table'[Asessor]), filter('Table', 'Table'[Days Since Last Review] <30) )