Forum Discussion
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 | 31 | A | 2 | 5 | 3 | ||
| A | 35 | B | 4 | 3 | 3 | ||
| A | 55 | ||||||
| A | 80 | ||||||
| A | 85 | ||||||
| A | 75 | ||||||
| A | 45 | ||||||
| A | 40 | ||||||
| B | 10 | ||||||
| B | 15 | ||||||
| B | 17 | ||||||
| B | 28 | ||||||
| B | 40 | ||||||
| B | 45 | ||||||
| B | 56 | ||||||
| B | 80 | ||||||
| B | 91 | ||||||
| B | 78 |
It's easy in excel but in power BI i can't figure out this.
Best regards,
NICK
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
7 Replies
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
