is it possible to have multiple search condition in filter funtion in MDX

Question

Can there be multiple search conditions in the "filter funtion" in mdx.

If possible how do I put

[Measures].[x] > 0 and [Measures].[y] = 0

in filter(set expression, search condition)

thanx

Answer 1

yes, I found that it can be added. I dont know what I tried earlier and it didnt work.

the filter function looks like this

filter(set expression, [Measures.[x] > 0 and Measures.[y] = 0)