Forum Discussion

YunJ's avatar
YunJ
Post Prodigy
5 years ago
Solved

How 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    
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    YunJ , Try like

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

amitchandak's avatar
amitchandak
Super User
5 years ago

YunJ , Try like

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