Forum Discussion
Solved
Count by Criteria
Hi All, need help in count in criteria:- <30 >=30 &<70 >=70 Sub No. A 20 Count by criteria A 29 Sub <30 >=30 & <70 >=70 A ...
Measure > 30 = CALCULATE(COUNTROWS(Table2),Table2[No.] < 30)
Measure 30&70 = CALCULATE(COUNTROWS(Table2),Table2[No.] >= 30, Table2[No.] < 70)
Measure70 = CALCULATE(COUNTROWS(Table2),Table2[No.] >=70)
that should give you the idea
and gives this result
Hi vanessafvg
Can it possible if criteria range is not filfull condition.
it show 0 instead of blank
| Sub | Count | <30 | >=30 - <70 | >=70 |
| A | 10 | 5 | 5 | |
| B | 10 | 5 | 3 | 2 |
See in A >=30 - <70 catagory
Regards,
NICK
Naveennegi119 Measure70 = CALCULATE(COUNTROWS(Table2)+0,Table2[No.] >=70)
you can just add +0
you can also use an if statement with isblank but adding + is easier
Naveennegi119what are you filtering on?