Ignore filter but not Variable base on filter

[palo173]

Hello,

in set analysis I want to ignore active filter but not variable base on filter.

I try to ignore Dealer, but Dealer define variable vDistrictDealer. Do you have same idea for this?

Max(Aggr(Sum({< Fakt = {'Def'}, Year = {"$(=Year(vMaxDatZap))"}, [District] = {'$(vDistrictDealer)'}, Dealer= >}[#Reg]), [District],[Brand]))

Thank you

[Qrishna]

whats your vDistrictDealer expression look like?

[palo173]

vDistrictDealer = District_short .... for example BA or BB or CA etc.

And District_short and Dealer are columns in dimension table Dealer.

[Qrishna]

when you say 'I try to ignore Dealer, but Dealer define variable vDistrictDealer. '- you want to ignore Dealer selections in vDistrictDealer = District_short  too?

[palo173]

I use filter for Dealer e.g. Dealer1. After that vDistrictDealer will value e.g. AB.

In my expression I want to Sum #Reg where District is AB, but I want to Sum #Reg for all dealers not only for Dealer1.

Max(Aggr(Sum({< Fakt = {'Def'}, Year = {"$(=Year(vMaxDatZap))"}, [District] = {'$(vDistrictDealer)'}, Dealer= >}[#Reg]), [District],[Brand]))

[Qrishna]

then why dont you try:

Max(Aggr(Sum({< Fakt = {'Def'}, Year = {"$(=Year(vMaxDatZap))"}, Dealer= >}[#Reg]), [District],[Brand]))

this sums up all while excluding Dealer selections

[palo173]

It ignores District AB, so it sums all regs for each district and returns max value. But I need only sum for District AB. Others districts are unimportant.

[Qrishna]

Max(Aggr(Sum({< Fakt = {'Def'}, Year = {"$(=Year(vMaxDatZap))"}, [District] = {'AB'}, Dealer= >}[#Reg]), [District],[Brand]))

This  sums up all [#Reg] for just [District] = {'AB'} while ignoring any selections on Dealer.

i would suggest to give a sample data and an expected output view, that would reduce all these clarifications.