topic Re: Measure that takes a specific value only in App Development

Measure that takes a specific value only

alespooletto — Mon, 29 Apr 2024 12:18:40 GMT

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.

Re: Measure that takes a specific value only

igoralcantara — Mon, 29 Apr 2024 12:27:59 GMT

Have you try this?

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

Re: Measure that takes a specific value only

alespooletto — Mon, 29 Apr 2024 13:59:04 GMT

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

Re: Measure that takes a specific value only

marcus_sommer — Mon, 29 Apr 2024 14:07:53 GMT

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))