topic Error when using Distinct Function: A table of multiple values was supplied where a single value was in DAX Commands and Tips

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

clint_powell — Thu, 04 Jan 2024 18:35:48 GMT

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 the same column.

I am trying to create a new column in a new table using the DISTINCT function, but I am recieving the error mentioned above.

The goal is to populate the new column in the new table with ONLY a list of the unique email addresses that are present in the fact table.

It was my assumption that DISTINCT was a fairly straightforward solution, but that does not appear to be the case. Any tips?

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

Dangar332 — Thu, 04 Jan 2024 18:38:41 GMT

hi, clint_powell

use all() function it give unique value of column

like below

all(tablename[columnname])

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

clint_powell — Thu, 04 Jan 2024 19:21:26 GMT

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

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

Dangar332 — Thu, 04 Jan 2024 19:29:35 GMT

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.

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

clint_powell — Thu, 04 Jan 2024 19:40:10 GMT

Thanks so much for the quick responses! But, I'm still getting an error, see below:

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

Dangar332 — Thu, 04 Jan 2024 19:46:05 GMT

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.

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

clint_powell — Thu, 04 Jan 2024 19:56:21 GMT

That was it, thanks so much!