How to use DAX return a table without blank rows?

Question

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

amitchandak · Accepted Answer

YunJ , Try like 
filter(distinct(Table[Division]), not(isblank([Division])))

Forum Discussion

How to use DAX return a table without blank rows?

1 Reply

Related content

Return "Specific value" from table 1, if not found, return value from table 2

VAR Table in RETURN statement

Return just one column from DAX table

Measure returning incorrect value

return table from switch