filter a virtual table after natualleftoin

[Anonymous]

why I can't  filter my variable table after I had made a leftjoin to get products without sales.

basically I have my dim_produtcs and fact_sales.

I'm doing  :

SUMMARIZE('dim_products','dim_products'[products])

SUMMARIZE('dim_products', 'dim_products'[programa],"total"
SUM ( 'fact_sale'[value] ))

var f = NATURALLEFTOUTERJOIN(products,sales)

var x= countx(FILTER(f,f[total] = ""),f[products]) 


why I can't use my columns from virtual table, there's no sense.

[wdx223_Daniel · Accepted solution]

when you refer the virtual table column, it is no need to add table name

[amitchandak]

@Anonymous , You can make a left join By adding +0 to a measures

Sales = SUM ( 'fact_sale'[value] )+0

Also, you can use this option