Multiple selection in a filter leads to incorrect results

Questions & Answers
2

Hi,

A multi-select field may multiply the measure value when used as a multi-selection page filter or calculated member. For example, if several multi-select field values are selected in a report, and an issue belongs to two, then the measure value is duplicated for this issue.

eazyBI offers a set of Distinc issue count measures to cover most of the use cases when looking for issue count. However, for a numeric custom field, such distinct measures are not created.

In your case, you might want to define a new calculated measure that would aggregate impacted transactions without publications for issues matching the filter criteria. The calculations would go through all issues and check if the issue has any value for the custom field (in your case, “Impacted transactions”) and matches the report context (filter criteria and values on report rows and columns).

Sum(
  --go through the set of issues and filter ones with a numeric value
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    NOT IsEmpty([Issue].CurrentMember.Get('Impacted transactions') )
  ),
  CASE WHEN --issue matches report context
    [Measures].[Impacted transactions created] > 0
  THEN --get custom field value as it is assigned to issue without duplications
      DefaultContext((
        [Measures].[Impacted transactions created],
        [Issue].CurrentMember
      ))
  END
)

Before using the code, please validate and update the property and measure names to match your eazyBI. Use autocomplete in the formula editor to get the right property and measure names.

More details on calculated measures and used functions are here:

See also this Community post on a similar use case:

Best,
Zane / support@eazyBI.com

1 Like