Hello,
I need to create a new calculated measure to get number of resolved issues which contain specific user(s) in custom field of type user picker (multiple users). In my case the custom field name is "Resolver(s)".
I have the query below, but it does not work as expected -> 0 results.
Aggregate(
Filter([Resolver(s)].Members,
CoalesceEmpty([Resolver(s)].[User].CurrentMember.get('key'), '')
MATCHES '.*(^|,)(username1|username2)($|,).*'
)
)
Any idea how should the query look like?
Thank you, Miroslav