For a calculated measure which counting the users for some filter - I need to exclude from the count few users if included in the filter.
For the following measure - I fail to add AND section to exclude list of users\ assignees.
Hi @Yaron_Moon
What is the layout of your report (what dimensions in columns/rows, page filters)?
Do you use the “Assignee” dimension also on the report to filter it?
As I understand your question, you could try hardcoding users you want to always exclude from the calculation
Count(
Filter(
[Assignee].[User].Members,
[Assignee].CurrentMember.Name <> "User Displayname1"
AND
[Assignee].CurrentMember.Name <> "User Displayname2"
AND
[Measures].[Issues closed]>0
)
)
Martins / eazyBI
1 Like
Thank you for the simple answer - still catching up on this MDX query language.
BR,
Yaron