Hey Clare -
A couple of years ago, I might have been able to answer this for you -- no more. My poor MDX skills have atrophied to nothing.
I frankly think you'll get a better response out on the Microsoft SSAS forums. There are very few glutton-for-punishment, MDX loving folks here
Please try the following MDX
Count(NonEmpty(Descendants([Response Dimension].[Response Type].Currentmember),[Measures].[Responses]))
oh no this will count the descendants of dimension, you actually want the count from fact table. I will try once I connect to my cube tomorrow my morning
Thanks for taking the time to reply - unfortunately most of the SSAS related forum responses don't work very well in Tableau - believe me, I've looked all over.
Thanks for looking into this - hopefully you can help answer what should be a fairly simple thing, but that has four fairly keen minds stumped at this end.
My fingers are crossed!
We have now figured it out!
The problem we had is that MDX does not recognise the names that we alias fields to. You always have to use the core name as specified within the cube. D'oh!
Thanks for everyone's time.
Thank you for the update and happy to hear that your problem is resolved