I currently have an MDX query/calculated measure as per the below:
[DaysOnListRange].[H1].[DaysOnListRange].&[Days 91 - 180]+ [DaysOnListRange].[H1].[DaysOnListRange].&[Days 181 - 365]+
[DaysOnListRange].[H1].[DaysOnListRange].&[Days 365+]
however it currently doesn't sum when there is a blank in the data.
How can I amend this query to include empty cells/only sum cells with data?
I've tried using nonempty but it doesn't appear to work in this context