using a calculated expression inside a set expression

[Anonymous]

Hi,

I need to define only those media whose budget >0 inside a set expression.

I might be like this:

{<Media={="expression"}>}

I tried this expression:

{<Media={="aggr(sum([Budget])>0, Media)"}>}

But it doesn't work.

Can you help me?

Thank you in advance,

Larisa

[sinanozdemir · Accepted solution]

Try this:

{<Media = {"=aggr(sum([Budget]), Media)>0"}>}

Hope this helps.

[sunny_talwar]

Slight correction:

{<Media = {"=Aggr(Sum([Budget]), Media) > 0"}>}

[sunny_talwar]

This might aslo work for you:

Sum/Count/Min/Max(If(Aggr(Sum([Budget]), Media) > 0, Measure))