show values based on condition

[tursic]

Hello.

I have a table with customers, and there is a measure with count(orders).

How can I show only the customers with count(orders)=0?

I have tried
=if(count(orders)=0 ,[customer],Null())

but this does not work.

Can anybody help me?

[GaryGiles]

For you customers dimension, try this expression:

aggr(only({$<[customer]={"=count(orders)=0"}>}) [customer]), [customer])

[tursic]

Thank you for the answer, but unfortunately it does not work. I get no results at all.

[GaryGiles · Accepted solution]

Sorry about that.  Looks like I had an extra ")" in my previous post.  Try this:

aggr(only({$<[customer]={"=count(orders)=0"}>} [customer]), [customer])

[tursic]

Thank you, this works.