mdx non empty

The MDX NON EMPTY Keyword will write all the specified members whose values are not NULL. For example, When we are displaying Non-performing products, you may find a few products with NULLs. To remove the NULLs, we can use this MDX NON EMPTY Keyword. Please refer below table to understand the NON EMPTY output. Measure 1 Value … Read more