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 combinat...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    nanma94,

     

    You may add a Boolean expression to FILTER Function.

     

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

     

     

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

nanma94,

 

You may add a Boolean expression to FILTER Function.

 

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