Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dax Filter Error

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 Cu...
Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

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