The hours spent are duplicated by the user if he is a member of several teams, if these teams are selected in the tempo teams multiple filter.
If you select “all logged by teamы” then there is no such problem
Is this a bug or is this how it should work?
Hi @clank232 ,
This is expected behavior justified by the fact that the hours spent by a specific user are genuinely attributable to each team where user is a member.
When multiple teams are selected, the hours for each team are retrieved separately and then summed up. This causes multiplication of values in case of multiple overlapping selections. When the dimension is being ignored by selecting the “All …” member, the individual groups are ignored, and the basic value is retrieved.
The basic workaround is to deduplicate the primary members by separating the application of relevant context from the data retrieval.
The expression to retrieve the hours spent by user(s) belonging to specific groups might be as follows.
Sum(
Filter(
[Logged by].[User].Members,
--primary condition - user relevant ot the current context
[Measures].[Hours spent]>0
),
--numeric value for sum
([Measures].[Hours spent],
--reset the multi-value dimension
[Logged by Group].DefaultMember)
)
The effect of the expression is as follows.
If you already put users on report rows and have multiple users in your eazyBI data cube, you might reduce the calculation load by reducing the applicable dataset for filtering by using the following expression instead of line 3.
DescendantsSet(
--iterate starting from the current selection
[Logged by].CurrentHierarchyMember,
--the member level for iteration
[Logged by].[User]),
Regards,
Oskars / support@eazyBI.com