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