Count rows based on filters

[jalaomar]

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?

[Bifinity_75 · Accepted solution]

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