Forum Discussion

jalaomar's avatar
jalaomar
Icon for Helper IV rankHelper IV
3 years ago
Solved

Count rows based on filters

Hello,   Would like to count number of rows with the following conditions  Duration >= 45 AND Percent Complete >= 1% where Tollgate Phase is Blank   Tried the following measure but doesn't seem ...
Need Help
  • Bifinity_75's avatar
    Bifinity_75
    3 years ago

    Hi jalaomar , you can create a calculate column:

    Column = if('Table'[Tollgate Phase]=blank() && 'Table'[Duration]>=45 && 'Table'[%]>=0.01,1,0)
     
    The sum of this calculate column is the result,
     
    Best regards
     
     
Bifinity_75's avatar
Bifinity_75
Icon for Solution Sage rankSolution Sage
3 years ago

Hi jalaomar , you can create a calculate column:

Column = if('Table'[Tollgate Phase]=blank() && 'Table'[Duration]>=45 && 'Table'[%]>=0.01,1,0)
 
The sum of this calculate column is the result,
 
Best regards