I am trying to get rid of all-null results in a calculated member, before applying CoalesceEmpty( , ) on a calculated member.

Basically:
- If tuple contains some NULL values, replace them with 0 -> CoaelesceEmpty does the job.
- If tuple contains *only* NULL values, discard them

My calculated member is as follow:

WITH MEMBER [Measures].[Foo] AS
CoalesceEmpty(
([Something.Something].CurrentMember, [Measures].[Derp]),
0
)

I tried to FILTER the tuple, but then I get "Error: no function matches signature CoalesceEmpty( , )"
The NON EMPTY clause doesn't work here either, and I do want it on the calculated member, not on the SELECT

Unfortunately, Mondrian MDX does not support the HAVING clause, which I think would solve my problem in this case.


Any help would be greatly appreciated.