I wrote it as below, but the value is not available.
It make in Measure.
Columns : Measure
Rows : Time
I’d like to know the Resolved value of the conditions below.
Help…
CASE
WHEN
[User_Define_Dimension].CurrentMember.Name MATCHES ‘AA’ OR
[User_Define_Dimension].CurrentMember.Name MATCHES ‘BB’
THEN
[Measures].[Issues resolved]
END
The calculated member looks for the selected member of “User_defined_dimension” and retrieves its name - if it matches, then returns the Issue resolved value accordingly.
In your report, the “User_defined_dimension” is not used at all, therefore, the measure always returns the default member of this dimensions (with the name “All User_defined_dimensions”) which does not match the conditions. In the result, you always get an empty value
You may do the following changes:
In “User_defined_dimension” create a calculated member that aggregates all members with names matching AA and BB, similarly to this member (I named the calculated member “AA and BB”)