MDX Question

Summary

MDX Question

Content

Hello fellows,

I am working on MDX query.

               1. (I want to find no.of stores for all my products which are in Level1 and Sales should be greater than 0 )-1 ;

I have written the script as below but it's not giving exact result. I need help now from experts

With

Member [Measures].[Number Of Stores]

as 'NonEmptyCount

  Filter(Geography.Levels(0).Members, Sales>0 )'

Select

{products.Levels(1).Members} on Rows,

{[Measures].[Number Of Stores]} on COLUMNS

FROM [ASOSamp.Sample]

 

Thanks,