Master item not influnced by the filter

[andreascansani1]

sum($(mSetTarget)[Qta Ordini Target])

how to write this measure that cannot influenced by this filter:

• Commercial_Flow
• Commercial_Family
• Patner_OwnerType

[Or]

What's in the variable mSetTarget? That would influence the syntax...

[andreascansani1]

{1 <Canale=P({$}Canale),Commercial_Cluster=P({$}Commercial_Cluster), TK_DATE={">=$(vMinDate) <=$(vMaxDate)"}>}

[Or · Accepted solution]

Nested variables in set analysis... oof.

You could try adding another set analysis of {<  Commercial_Flow =, Commercial_Family = , Patner_OwnerType = >} which will result in the main aggregation ignoring any selections made on those three fields, but do keep in mind that won't impact the behavior of the existing set analysis or whatever is contained within the MinDate and MaxDate variables.

[andreascansani1]

you are right because in the Vmaxdate there was an impact in the set analysis, so at the end the expression was:

Date(Floor(max({<Commercial_Flow=,Commercial_Family=,Partner_OwnerType=>}Date)))

but at the end I need to  exclude all section(FILTER) except some value(filter), that are : CHANNEL, CLUSTER

do you know how to do it ? in my opinion is the opposite things