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

[PBI_newuser]

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:

[amitchandak · Accepted solution]

@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