topic filter a virtual table after natualleftoin in DAX Commands and Tips

filter a virtual table after natualleftoin

Anonymous — Tue, 08 Dec 2020 01:27:22 GMT

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.

Re: filter a virtual table after natualleftoin

amitchandak — Tue, 08 Dec 2020 01:56:29 GMT

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

Re: filter a virtual table after natualleftoin

wdx223_Daniel — Tue, 08 Dec 2020 02:23:11 GMT

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