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
Naveennegi119what are you filtering on?
I'm using Chiclet slicer,
problem is
| Selected Apple in slicer | ||||||||
| ChicletSlicer | Sub | <30 | >=30 - <70 | <=70 | ||||
| Apple | A | 5 | 5 | |||||
| Mango | B | 5 | 3 | 2 | ||||
| Banana | ||||||||
| Measure >30 = CALCULATE(COUNTROWS('FT Test Result'),'FT Test Result'[Percentage]<30) | ||||||||
| After using this formula | ||||||||
| Measure >30 = CALCULATE(COUNTROWS('FT Test Result')+0,'FT Test Result'[Percentage]<30) | ||||||||
| Selected Apple in slicer | ||||||||
| ChicletSlicer | Sub | <30 | >=30 - <70 | <=70 | ||||
| Apple | A | 5 | 0 | 5 | ||||
| Mango | B | 5 | 3 | 2 | ||||
| Banana | A | 0 | 0 | 0 | ||||
| B | 0 | 0 | 0 | |||||
| A | 0 | 0 | 0 | |||||
| B | 0 | 0 | 0 |
showing apple value with 0, that's good
but also show other data value with 0
Regards,
NICK