cancel
Showing results for
Did you mean:
Post Prodigy

## How to exclude total job by quarter by employee in a measure

Hi, I would like to calculate the measure "Productivity" with the below criteria:

• Exclude the employee from calculation of "Productivity" if he has Total WO less than 3 or Total Hours less than 5 in a quarter.

Here is the sample.

Current Measure:

Expected Output:

1 ACCEPTED SOLUTION
Super User

@PBI_newuser , Assume you have quarterly working hours measure or simple sum measure

QTD hours= CALCULATE(SUM(Table[Hours]),DATESQTD(('Date'[Date])))

Hours Qtr > 5

sumx(filter( values(Table[User]), [QTD hours] >5 ) , [QTD hours])

You can use what if numeric field measure in place of 5

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Super User

@PBI_newuser , Assume you have quarterly working hours measure or simple sum measure

QTD hours= CALCULATE(SUM(Table[Hours]),DATESQTD(('Date'[Date])))

Hours Qtr > 5

sumx(filter( values(Table[User]), [QTD hours] >5 ) , [QTD hours])

You can use what if numeric field measure in place of 5

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors