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]