cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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