Dynamic Array formula works on one table, not on another?

[Tarver]

I've got a table, DataTable, that has a monthly breakdown of sales. I use the following formula to return a list of unique entries in the field [Category]:

=UNIQUE(DataTable[Category])

It works with no problem.

I've also added a new table, AltDataTable, with the same fields, but with a daily breakdown of sales. I can use the same formula on this table to return the same results.
=UNIQUE(AltDataTable[Category])

However, other formulas simply don't work with the new table. I can't figure out why.

This formula will work on the original table:
=UNIQUE(FILTER(DataTable[ProductCategory],(DataTable[ProductCategory]<>"NA")*(DataTable[Category]="Gift Card (Mall)")))

However the new formula for the AltDataTable will not work, and it returns an #N/A error:
=UNIQUE(FILTER(AltDataTable[ProductCategory],(AltDataTable[ProductCategory]<>"NA")*(AltDataTable[Category]="Gift Card (Mall)")))

It's baffling to me! I've triple-checked the names of the fields (I've even copied them from the original and pasted them into the new table.) I've re-typed the formula and copied then edited the formula. I've worked it backwards and re-edited the formula to remove the "Alt" prefix and it works.

Any ideas what I can try? Am I missing something obvious?

 

[Fluff]

Do you have any #N/A errors in the Alt Table?

 

[Tarver]

Do you have any #N/A errors in the Alt Table?

YES! In 13,000 lines, there is one #N/A error. Thank you. I'm ashamed to admit that never occurred to me, and I've been using Excel for enough years to know better.

Thank you for taking the time to answer. This is not the first time you've saved me, Fluff! I appreciate it more than you know.

 

[Fluff]

Glad to help & thanks for the feedback.