VALUES function combined with NOT(ISBLANK function

[Anonymous]

Hi,

With the values function, I can create a new table with a column with unique values.

But it came back with a blank in it. How can I get rid off the blank in my table?

(NB powerquery would not work, because I use "New Table".

I tried the following DAX functions:

VALUES(NOT(ISBLANK(Tabel1Column1)))

NOT(ISBLANK(VALUES(Tabel1Column1)))

Thank you for your feedback.

[amitchandak · Accepted solution]

@Anonymous , try like

filter(VALUES(Tabel1[Column1]),  NOT(ISBLANK(Tabel1[Column1])) )

or

filter(distinct(Tabel1[Column1]),  NOT(ISBLANK(Tabel1[Column1])) )

[Anonymous]

Worked like a charm, thx!