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!