Looking for a way to create a null filter

stefan-heusel

Hello together,
we are looking for a way to create a null-filter for a hyperblock like this:

Parent and children values are all 0 = Do not show.
Parent is greater than 0 = Show
Parent is 0, but at least one child is greater than 0 = Show parent and child (where the value is greater than 0)
All children with values greater than 0 = Show

Is there a way to do such a thing via MDX? 
Best regards,
Stefan

vikas-sharma

Hi Stefan,

I believe you can achieve this by setting the value filter to Null instead of 0. This way, it will display the parents that are 0 but won’t show those that are null. Hope this helps!