How to use DAX return a table without blank rows?

[YunJ]

Hi,

I used DISTINCT to return a distinct column as a dimention table. But I don't want the blank rows.  I'm wondering can I return a table without the blank rows? 

Thanks

Yun

[amitchandak · Accepted solution]

@YunJ , Try like

filter(distinct(Table[Division]), not(isblank([Division])))