topic Re: Calculated column, excluding Accounts according to document type in DAX Commands and Tips

Calculated column, excluding Accounts according to document type

Anonymous — Fri, 24 Sep 2021 11:49:42 GMT

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.

Re: Calculated column, excluding Accounts according to document type

amitchandak — Fri, 24 Sep 2021 13:02:13 GMT

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)))

Re: Calculated column, excluding Accounts according to document type

Anonymous — Tue, 28 Sep 2021 07:09:57 GMT

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?

Re: Calculated column, excluding Accounts according to document type

Anonymous — Wed, 29 Sep 2021 06:22:09 GMT

Anyone?

Re: Calculated column, excluding Accounts according to document type

ERD — Wed, 29 Sep 2021 07:44:02 GMT

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

Re: Calculated column, excluding Accounts according to document type

Anonymous — Thu, 30 Sep 2021 07:13:37 GMT

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.