Measure that takes a specific value only

[alespooletto]

Hello.

I have this measure that does a calculation for all employees, and then changes for specific employee when I select. But I want another measure that doesn't change when I select an employee and remains the same.

AvG( Aggr({< Weekday = {'Lu', 'Ma', 'Me', 'Gi','Ve'} >} Availability, Date))

I tried to put Employee (the field with employee name in) but it still changes.

[igoralcantara]

Have you try this?

AvG( Aggr({< Weekday = {'Lu', 'Ma', 'Me', 'Gi','Ve'}, Employee= >} Availability, Date))

[alespooletto]

Thank you, I did try it and it seems it still changes when I select a specific user.

[marcus_sommer · Accepted solution]

Each part of a nested aggregation may need a set statement to consider the same or an adjusted selection state, like:

avg({set statement} aggr({set statement} count({set statement} Field), Dim))