cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

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

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

Top Solution Authors
Top Kudoed Authors