I have created a custom user defined measure called DueNextYear. The formula for this measurement is:
[Issue].CurrentHierarchyMember.get(‘Completion Due Date’),
WHEN CBool(1) THEN 1
WHEN CBool(0) THEN 0
However, when this is generated in a chart and I ask that the rows and columns be totaled only the columns are totaled (see screen shot below) and the row total returns zero. Why would this be? Also the values aren’t rolled up to the hierarchies.