Forum Discussion

clint_powell's avatar
clint_powell
Frequent Visitor
2 years ago
Solved

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

New user here trying to navigate unexpected results. I have a fact table that has multiple entries for repeating data points (email addresses). The same email address is listed multiple times within ...
  • Dangar332's avatar
    Dangar332
    2 years ago

    hi, clint_powell 

    use all() function it give unique value of column

    like below

    all(tablename[columnname])

  • Dangar332's avatar
    Dangar332
    2 years ago

    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.

clint_powell's avatar
clint_powell
Frequent Visitor
2 years ago

Thanks! Is there a way to pull in all the values, but ignore the nulls?

Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

hi, clint_powell 

try below

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.