How do I create a measure that filters with "AND" and "OR" Conditions from many different tables.

[WTreadway]

Hello,

I am trying to create a measure the aggregrates Net Balance but we need to filter that on a few different conditions.
We have three Tables:
Balance (Factish table), Cost Center (DIM), Account(DIM).

The business logic is: Sum all Net Balances where:

Balance Type is "Actual", the Cost Center Parent is "Sales" and the Acct 5 is "OP"

or

Balance Type is "Actual", the Cost Center Code is "2202", and the Acct 5 is "OP

or

Balance Type is "Actual", Acct 6 is "Other"

My Dax is =

Actual Sales Expense = CALCULATE(SUM('GL Balances'[Period Net Balance]),'GL Balances'[Balance Type] = "ACTUAL", Filter(Account,Account[Acct 5]  = "Cost of Operation" || Account[Acct 6] = "Other"),Filter('Cost Center','Cost Center'[Cost Center Code] = "2202" || 'Cost Center'[Cost Center Parent] = "Sales"))

But this doesn't seem to work, I think I am getting other comibantion that aren't intended.
I tried to write the DAX like this:

CALCULATE ( SUM ( 'Balance'[Net Balance] ), 'Balance'[Balance Type] = "ACTUAL" && 'Cost Center'[Cost Center Parent] = "Sales" && 'Balance'[Acct 5] = "OP" || 'Balance'[Balance Type] = "ACTUAL" && 'Balance'[Cost Center Code] = "2202" && 'Balance'[Acct 5] = ",OP" || 'Balance'[Balance Type] = "ACTUAL" && 'Balance'[Acct 6] = "Other")

However, this doesn't not work. I get the following:

Any help or direction on this would be great. Thanks in advanced. 

[AnthonyGenovese]

Don't use Filter, do the following instead

Actual Sales Expense =
 SUM( 'GL Balances'[Period Net Balance] ),
'GL Balances'[Balance Type] = "ACTUAL",
OR(
Account[Acct 5] = "Cost of Operation",
Account[Acct 6] = "Other"
),
OR(
'Cost Center'[Cost Center Code] = "2202"
,'Cost Center'[Cost Center Parent] = "Sales"
)
)

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!

[WTreadway · Accepted solution]

This did not work. Still have the same issue. I solve this by create a Variable in my measure to hold each criteria groups. Then return the Variables added together.

Measure = 
var _Cat1 = Cat 1 logic

var _Cat2 = Cat 2 logic

var _Cat3 = Cat 3 logic

return

(_Cat1 + _Cat2 + _Cat3)