Ignoring one filter selection and keeping others

[G3S]

hi

there is set analysis used in a straight table. There will be multiple dimensions filtered on. however, one of them needs to be ignored for this measure . dimension to be ignored = Forwarder.

set analysis:

Sum({$<AFWeekType={'AllocForecast'}>}aggr(max(distinct AFAllocation), (Key1,OrderKey)))

There are other measures in the table that are ok to be affected by the 'Forwarder' filter. just this one measure needs to ignore selection. Tried the following but not returning the required result:

Sum({Forwarder}{$<AFWeekType={'AllocForecast'}>}aggr(max(distinct AFAllocation), (Key1,OrderKey)))

Appreciate your help please

[sujana1621]

Hi,

Can you try this...

Sum({$<Forwarder=,AFWeekType={'AllocForecast'}>}aggr(max(distinct AFAllocation), (Key1,OrderKey)))

[BrunPierre · Accepted solution]

Perhaps, like this.

Sum(DISTINCT{<Forwarder=>}Aggr(Max({$<AFWeekType={'AllocForecast'},Forwarder=>} AFAllocation), Key1, OrderKey))

[G3S]

That worked. thank you. 
I had to remove the distinct to show the correct numbers.