Why my set analysis is not working for all my group ?

[alespooletto]

Hello, 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) * Avg_Time,
        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? 

[TauseefKhan]

Hi @alespooletto,

Check with this:


Sum(
Aggr(
Count({< ACTION_CODE = {'LABOR_OFF'}, Employee= >} distinct MainSFC) * Avg_Time,
MainSFC, Employee
)
)
/
(
Sum(
Aggr(
Count({< Employee= >} distinct WorkingDay) * 7.5 * 60,
Employee
)
)
- Sum(Absence) * 60
)

***Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.***

[alespooletto]

Thank you so much, unfortunately this measure as it is does not show me any values. Thanks for the help though, I am struggling to understand set analysis