cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper 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?

1 ACCEPTED SOLUTION
Solution 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

Solution 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

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors