Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
@dan--ctvmarks - I don't get the use of CALCULATE in the previous responses, you could do this with a simple FILTER statement.
Measure = COUNTROWS(FILTER('Table',[Age] < 18))
@dan--ctvmarks - I don't get the use of CALCULATE in the previous responses, you could do this with a simple FILTER statement.
Measure = COUNTROWS(FILTER('Table',[Age] < 18))
CALCULATE(COUNTROWS('Table'), 'Table'[Age] < 18)
Try this 🙂
Try like
CALCULATE(COUNTAX(Employees, Employees[Age]), filter(Employees, Employees[Age] < 18))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |