MDX: How to replace null value

Question

How to replace null values in mdx.

I think this has already been asked: http://stackoverflow.com/questions/25851274/mdx-how-to-replace-null-values-with-0-in-measures-members — whytheq, Mar 29 '16 at 09:36

score 1 · Accepted Answer · answered Mar 29 '16 at 09:35

1

Maybe something like this:

WITH
  MEMBER [Measures].ComputerSalesNew AS
    iif(
       isempty([Measures].ComputerSales),
       0,
       [Measures].ComputerSales
    )

answered Mar 29 '16 at 09:35

whytheq

hi @whtheq- can u please answer the below question http://stackoverflow.com/questions/36282243/mdx-i-need-column-count-based-on-the-total-rows – Yugandhar Mar 29 '16 at 10:57

1 Answers1