How to filter values 0 in an array

[littlevillage]

Hi,

I need to filter values 0 in an array, and hope the result a dynamic array

I have added an image and the link of sample file

Hope for your help

Thank you

[#2 · Accepted solution]

@littlevillage Change the first variable "x" in the LET formula to this:

x,UNIQUE(FILTER(Table1[Column1],Table1[Column1]<>0)),

[#3]

@Riny_van_Eekelen 

it's unbelievable, you make it so simple

Thank you so much