Count of the number of options selected in a multi-select drop down

[Tamer]

So I am having an issue creating a new measure which will count the number of items selected in a multiselect field.

so it should return the count of how many options is selected in this field and then I will work on adding formatting later on.

[janis.plume]

Hi,

The following formula counts the number of selected items in the dimension:

Count(ChildrenSet([Project].CurrentHierarchyMember))

This formula refers to the dimension from the report pages (in this case, the Project):

Kindly,
Janis, eazyBI support