Remove blank rows from a derived master table

[nanma94]

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

[v-chuncz-msft · Accepted solution]

@nanma94,

You may add a Boolean expression to FILTER Function.

NOT ( ISBLANK ( Sales[GEO] ) && ISBLANK ( Sales[Country] ) )