Set Analysis to ignore Filter Pane

[Kat92]

Hi All,

I want to adjust a calculation in set analysis, so that it will ignore the filter Column1 from my report.

Column1 is in a filter pane in my sheet and the calculation is below:

Sum(Aggr(Value, Year_Month,[Name]))

Value column is found in Fact table, Name as well. The COlumn1 belongs in dimensional table connected with this Fact.

Could you please assist?

Thanks in advance

[Aasir]

to ignore Column1

Sum({<Column1 = >} Aggr(Value, Year_Month, [Name]))

[Kat92]

I have tried, and does not work.

When the filter in Column1 is having a selection the calculation is affected.

Not sure what is happening since I have tried in multiple other calculations the same tactic but I do not understand completely how Aggr function is working