Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
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.
Thanks so much for the quick responses! But, I'm still getting an error, see below:
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.
That was it, thanks so much!
hi, @clint_powell
use all() function it give unique value of column
like below
all(tablename[columnname])
Thanks! Is there a way to pull in all the values, but ignore the nulls?
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.
User | Count |
---|---|
58 | |
21 | |
18 | |
16 | |
12 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |