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 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!

1 Reply

  • 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