crossjoin show back a blank value that I previous removed

[perezco]

HI again,

Why a second virtual table with Crossjoin show back a blank value when I previously removed in a previous virtual table?

First virtual table( the blank value is not show up here):
SUMMARIZECOLUMNS (
Data[ProductG],
CALCULATETABLE ( Data, Data[ProductG] <> BLANK () )

)

I also try

SUMMARIZECOLUMNS(Data[ProductG], filter(data,Data[ProductG]<>blank()))

Second virtual table(but it is back the blank value for ProductG column):

Table.Bridge.v2 =
VAR progenerationV =
CROSSJOIN ( ROW ( "Type", "ProductG" ),
VALUES ( 'TBL.ProductG'[ProductG] ) )
VAR bregionV =
CROSSJOIN ( ROW ( "Type", "Region" ),
VALUES('TBL.BRegion') )

RETURN
union(progenerationV ,bregionV )

Thanks in advance...

[v-juanli-msft]

Hi @perezco 

Crossjoin function would return a table that contains the Cartesian product of all rows from all tables in the arguments.

So the blank value also shows in your result.

Please show some example data and expected result, i'm willing to work out this problem.

Best Regards
Maggie