concat function with a set expression

[Anonymous]

Hi,

My task is to display the name of the media which has a zero budget disregarding a user's selection in the field 'media'.

I tried this formula:

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

It doesn't work the way I need. It still takes into account a user's selection in the field 'media'.

How can I fix it?

Thank you in advance,

Larisa

[MK_QSL · Accepted solution]

=Concat({<Media=>}aggr(if(sum({<Media=>}Budget)=0,only({<Media=>}Media)),Media),',')

[Anonymous]

Thank you!