MDX Question
Summary
MDX QuestionContent
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,
0