-
1 Attachment(s)
MDX count problem
Very new to MDX. I have the simple MDX query below that returns the data in the attached image. All I want to do is be able to get a count of the Coop members that have a value greater than 1. So in the data below, the count should be 2.Seems like this should be very simple, but I cannot get the syntax down.
select [Measures].[Vote Count] on axis(0),
[Store].[Coop].Members on axis(1)
from [Cube]
-
What's in the Measure?
Can you tell us what is in [Measures].[Vote Count] - that is, if it is a calculated measure? Or is it a simple measure designated as a "count?"
Thanks.
Bill