Need equivalent DAX Query for SQL Query

[likhithar]

Hello All,

I have the SQL Query,I need equivalent DAX measure

Select sum(a.sales)

From Sales table a

Where a.orderid not in (select b.orderid from status table b where b.status="S").

This is the SQL Query.

TIA

[amitchandak · Accepted solution]

@likhithar , Try new measure

new measure =

var _tab = summarize(filter(Table, Table[status] = "S"), Table[Orderid])

return

sumx(filter(sales, not(sales[orderid] in _tab), sales[sales])