$ filed Exclusion

[nag78936]

sum({ <
OrderYear = {2022},
Country = $::Country,
EmployeeName =$::EmployeeName
>}Sales)

i am getting - 1.0M CORRECT

sum({ <
OrderYear = {2022},
Country = $::Country,
Category = $::Category
>}Sales)
I am getting -923.3k Wrong (i Should get same before selection.)

There is no selection in any filter pane

Why i am getting wrong after adding category in modifier

[tresesco]

Are you using alternate states? I see a difference in EmployeeName in set analysis

[nag78936]

No,Alternate states

I just testing filed exclusion

i should get same output,if nothing is selected in filter pane

Start schema with 100% subsetration

[nag78936]

There is one Blank row in Category filed
will that impact result?

[tresesco]

If you are really trying for exclusion, $::field - is not for exclusion. Instead, that is for current selection in default state. For exclusion, you try like :  Sum({<Category=,>}Sales)