Dedupe based on customer field

You are correct. eazyBI will double count any numeric value if you are using multiple value dimensions with multiple selections. We have some distinct count measures for some default measures on issue count. However, we do not have default support for numeric value distinct sum.

You would like to use a calculation on an issue level using properties or a tuple with default member of multiple value dimension to get a correct sum there. Here is an example formula that could work instead of default measure Story Points created:

SUM(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  NOT isempty([Measures].[Issue Story Points])
  ),
 CASE WHEN [Measures].[Issues created] > 0
 THEN
 [Measures].[Issue Story Points]
 END
)

Here is my report example. I am using another multi-value dimension Fix version with multiple selections there. The default measure Story Points created double counts some issues.

Daina / support@eazybi.com