having 'Measure' > 0 syntax does not work in mdx query

1 vote

1 answer

2418 views

                          Hope you're doing well
I've written an MDX query as you can see below :

    with member [Measures].[TOTAL] AS
    SUM(Periodstodate([DimTime].[Year].[(All)] ,[DimTime].[Year].currentmember)
    ,[Measures].[IndentCount])

    Select {[Measures].[IndentCount],[Measures].[TOTAL]}  
       having [Measures].[IndentCount] > 0 on 0 , 
	   non empty [DimTime].[Year].[Year] on 1
    from [Procurement]

The problem is despite using having [Measures].[IndentCount] > 0 I still see the null value for my measure as you can see below :

 .
I want to know what the problem would be???
I have this problem even when I use Filter function

Thanks in advance
                        

Asked by Pantea (1510 rep)

Apr 8, 2019, 10:26 AM
Last activity: Apr 15, 2019, 01:22 AM

having 'Measure' > 0 syntax does not work in mdx query

Related Questions