Forum Discussion

nanma94's avatar
nanma94
Icon for Helper III rankHelper III
8 years ago
Solved

Remove 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

1 Reply