Error when using Distinct Function: A table of multiple values was supplied where a single value was

hi, clint_powell 

use all() function it give unique value of column

like below

all(tablename[columnname])

Hi, clint_powell 

Syntax error for all() function

See my code properly

You miss  ) to finish all() function

filter(

  all(tablename[columnname]),

 tablename[columnname]<>blank()

)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.and don't forgot to give kudos.