Using AGGR() on Filter Pane only shows one selection. How to show multiple selections?

[rhhlee]

Hello,

Currently, I am applying a filter to a dimension - so that only Contracts with a Saving > 0 will display on the filter.

=AGGR(IF(Sum(Savings)>0,[Contract_Table.Contract],null()),[Contract_Table.Contract])

Currently, this is working correctly - in that the Filter Pane is showing only the Contracts where Savings is over 0.

However, the moment I select one entry in the Filter Pane, all other options disappear:

Is there a way by which I can still show the other options in a Filter Pane (greyed out) but a user can have the option of selecting multiple contracts?

[qv_testing]

I think if we are using AGGR then when user selects something all the attribute will not appear.

My suggestion, if all fields are in same table, you can aggregate at script level

LOAD * where Savings>0;
LOAD [Contract_Table.Contract] as Filter,
           Sum(Savings) as Savings
Resident TableName
group by [Contract_Table.Contract];

[vinieme12 · Accepted solution]

As Below

=aggr({<[Contract_Table.Contract]=>}only({<[Contract_Table.Contract]={"=sum(Savings)>0"}>} [Contract_Table.Contract]), [Contract_Table.Contract])