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 so much for the quick responses! But, I'm still getting an error, see below:

 

Dangar332's avatar
Dangar332
Resident Rockstar
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

    That was it, thanks so much!