Filter on variable is empty

[bekart]

Dear Community,

last time I am trying to solve one issue.
Table was created few years ago and worked perftectly till last weeks.

On screenshot you can find the example of data set and I can't understand why I am not able to use filter (no data shown in list) on variable "variable_not_working" if the data is retrieved successfully (table cointains proper values)...

In that case the table is showing #ERROR... For example above the table it's used one command:

=Count([Customer Code]) Where (IsNull([dummy column]) And [Year Filter] = "Current Year" And [DC]="Dealer" And [variable_not_working] InList( "Indirect";"Indirect Broker" ))

INB4 - variable_not_working is simple Dimension.

Thanks in advance!

[former_member1161]

Would try to break down the formula logic and check where is stops working.

What's the logic behind the "variable not working"?

also: are there any hidden filters/ lower aggregation levels which are part of the table but aren't shown?