Forum Discussion
YunJ
Post Prodigy
Post ProdigyHow to use DAX return a table without blank rows?
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
YunJ , Try like
filter(distinct(Table[Division]), not(isblank([Division])))
amitchandak
Super User
Super UserYunJ , Try like
filter(distinct(Table[Division]), not(isblank([Division])))