Forum Discussion
DISTINCT command pulls BLANKS
Hi there,
We are creating DISTINCT tables. We are getting distinct rows, but we are also getting a BLANK row.
How do we remove the BLANK row so we only have non blank rows?
We looked at:
FILTER(DISTINCT(Transactions[CheckInLoc]), <> BLANK)
Thanks!
Just change the column instead of all table
Table = DISTINCT(FILTER(VALUES(Transactions[CheckInLoc]),LEN(Transactions[CheckInLoc])>0))
8 Replies
Hi, please try with this:
Table = DISTINCT(FILTER(Transactions,LEN(Transactions[CheckInLoc])>0))
Hi,
Nice try and thank you very much for your suggestion.
However...
I only want the CheckinLoc column with the unique values for that column. Your query pulls all columns.
Just change the column instead of all table
Table = DISTINCT(FILTER(VALUES(Transactions[CheckInLoc]),LEN(Transactions[CheckInLoc])>0))
