Reply
avatar user
Anonymous
Not applicable

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

Mro_0-1632484088372.png

 

Expected result:

Mro_1-1632484132331.png

Thank you for your help. 

 

1 ACCEPTED SOLUTION
avatar user
Anonymous
Not applicable

@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. 

View solution in original post

5 REPLIES 5
avatar user
Anonymous
Not applicable

@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. 

avatar user
Anonymous
Not applicable

Anyone? 

ERD
Community Champion
Community Champion

@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!

amitchandak
Super User
Super User

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user
Anonymous
Not applicable

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?

 

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)