MDX: Count number of dimension members

If you are trying to count the number of dimension members via MDX, where your measure is [Measure].[Item Quantity] and dimension is [Item].members, you can write your MDX query as: withmember [Measures].[blah] as ‘Count(Crossjoin({[Item].members}, {[Measures].[Item Quantity]}), EXCLUDEEMPTY)’select {  [Measures].[Item Quantity], [Measures].blah} on columns, {  [Item].children} on rowsfrom [Cube]  

Rate this: