Calculated column, excluding Accounts according to document type

[Anonymous]

Dear All, 

Please assist. I need to create calculated column which will exlcude ALL documents from assigned account, if given account has any DW ducument.  My attemts resulted only in excluding single documents. 

Table: Export

Expected result:

Thank you for your help. 

[Anonymous · Accepted solution]

@ERD @amitchandak 

Thank you for your effort. I've made it differently. I've duplicated query, filtered out documents other than "DW", and comapred columns Account.

This is small model, such solution is enough. 

Thank you. 

[Anonymous]

Anyone? 

[ERD]

@Anonymous , please, provide your sample data in a table format, not an image.

[amitchandak]

@Anonymous , I think you need a measure like below and plot that with Account in table visual

measure =
var _max = countx(allselected(Table), Table[Account] = earlier(Table[Account]) && Table[Document Type] ="DW")
return
calculate(sum(table[Value]), filter(Table, isblank(_max)))

[Anonymous]

Thank you @amitchandak , Unfortunatelly following erro appears: "DAX comparison operations do not support comparing values of type True/false with values of type Text "

Is there a solution that can be used in calculated column?