Results 1 to 2 of 2

Thread: MDX count problem

  1. #1
    Join Date
    May 2009
    Posts
    1

    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]
    Attached Images Attached Images

  2. #2
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •