I Wan to add balance in Column B if column D contains A or D

[jmercado]

Hello,

I wan to add balance on column B if the column D cotains A or D.

I can do it if its just one value using this formula:

Balance Of A&D = CALCULATE(SUM(Table1[columnB]),'Table'[ColumnD] = "A") 

Column A	Column B	Column D
John	$       200.50	A
Peter	$       320.00	D
Sam	$       156.32	B
Juan	$       856.33	X
Noan	$       468.00	Y
Loli	$       134.30	A
John	$       200.50	D
Peter	$       320.00	F
Sam	$       156.32	A
Juan	$       856.33	D
Noan	$       468.00	B
Loli	$       134.30	D

Thank you 

[parry2k · Accepted solution]

@jmercado try this

Balance Of A&D = CALCULATE(SUM(Table1[columnB]),'Table'[ColumnD] IN { "A", "D"} )

oR

Balance Of A&D = CALCULATE(SUM(Table1[columnB]),'Table'[ColumnD] = "A" || 'Table'[ColumnD] = "D" )  

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡