Forum Discussion

Naveennegi119's avatar
Naveennegi119
Icon for Helper III rankHelper III
8 years ago
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 ...
Need Help
  • vanessafvg's avatar
    vanessafvg
    8 years ago

    Naveennegi119 

     

    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

     

     

     

     

Naveennegi119's avatar
Naveennegi119
Icon for Helper III rankHelper III
8 years ago

Hi vanessafvg,

 

it's working but not usable with filter or slicer.

 

but thanks for help

 

 

Regards,

NICK