Dax Filter Error

[Anonymous]

I cannot get my DAX filter to work, every time I try I get the error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value." 

FILTER(Query,Query[DP CustomerDP HierarchyDP Entity] = "ACER")

I am trying to make a new table with just filtered results where the customer is ACER

Any help would be great!

[Nathaniel_C]

Hi @Anonymous ,
Try adding MAX()

FILTER(Query,MAX(Query[DP CustomerDP HierarchyDP Entity] = "ACER"))

or go to Power Query, select your table, filter the table for "ACER", and save it as a new table.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel