Question about a measure that needs to be set for certain employees only

alespooletto — Wed, 22 May 2024 06:30:14 GMT

Hello,

I have written a post about this question recently, but I am currently stuck once more. I can't understand how set analysis works in this case, because despite having inserted into the measure what I am looking for and having told the measure to use the set analysis over each function that needs it, the results do not match.

See screenshots below, when I don't select any employee, the measure 'Team Measure' works fine:

However, when I select an employee, the measure suddenly turns to the same output as the employee selected:

This is the measure I am currently using:

// All Other Employees Measure Sum( Aggr( {< Employee= >} // Ignore selection of Employee Count({< ACTION_CODE = {'LABOR_OFF'} >} distinct MainSFC) * Time_Product, MainSFC, Employee ) ) / ( Sum( Aggr( {< Employee= >} // Ignore selection of Employee Count(distinct WorkingDay) * 7.5 * 60, Employee ) ) - Sum(Absence) * 60 )

Can someone please help me figure out what I am doing wrong?

Re: Question about a measure that needs to be set for certain employees only

ali_hijazi — Wed, 22 May 2024 08:18:34 GMT

in the denominator you need to use the total
for example:
count(employee) / count(total {<employee=>}employee)

topic Re: Question about a measure that needs to be set for certain employees only in App Development

Question about a measure that needs to be set for certain employees only

Re: Question about a measure that needs to be set for certain employees only