Forum Discussion
jalaomar
3 years agoHelper IV
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
- Bifinity_75Solution Sage
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