- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculated column, excluding Accounts according to document type
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.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Anyone?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous , please, provide your sample data in a table format, not an image.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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)))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
06-20-2024 02:19 PM | |||
07-31-2024 07:56 PM | |||
12-13-2023 06:38 AM | |||
07-08-2024 10:48 AM | |||
08-18-2024 09:59 PM |