Forum Discussion
nanma94
Helper III
8 years agoRemove blank rows from a derived master table
I have a sales table, where I use create table function to derive a geo/country master table using GeoCountryTable = ALLNOBLANKROW( Sales[GEO], Sales[Country])
It gives me all the unique combination fo geo/country but also returns a blank row. this blank row is causing issue when I join with other fact tables. How can I remove this?
Thanks
NM
You may add a Boolean expression to FILTER Function.
NOT ( ISBLANK ( Sales[GEO] ) && ISBLANK ( Sales[Country] ) )
1 Reply
- v-chuncz-msft
Community Support
You may add a Boolean expression to FILTER Function.
NOT ( ISBLANK ( Sales[GEO] ) && ISBLANK ( Sales[Country] ) )