Filter in MDX

Filter in MDX query

NaN error was encountered in SSRS MDX reports. Usage of Single.IsNaN(Fieldname) did not fix the issue. To remove the NaN error we used the iif statement for the denominator filed to replace 0 with 1

IIF([Meaures].[Plant Share] = "0" , 1, [Meaures].[Plant Share])

We also used  

1.       Not IsEmpty( [Measures].[COG_OQP_INT_m11] ) 

2.       Having  [Measures].[DC Out of Stock Ind] >0

3.       Non Empty {

[Location].[Location].[COG_OQP_USR_SOUTH LL (MONTAGUE)]}