Forum Discussion

jalaomar's avatar
jalaomar
Helper 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 to work (didn't add condition that tollgate phase should be blank)

#project with perc = CALCULATE(
COUNTROWS('Governance Dimesions'),
FILTER('Dimesions', 'Dimesions'[Schedule Duration] >= 45 || 'Dimesions'[Governance[PertentageCompletedActual]]] > 1 ))
 
anybody who knows how to manage?
 
  • 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
     
     

1 Reply

  • 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