Order of logical operators or nesting of logical operators in a Calculate statement

[dgjacobson]

Hello:

I created the following measure to sum account entries by filtering on department and account. It does not work. The Department filter needs to apply to all of the Accounts but in the way this is written, it does not. I can't use () inside of the CALCULATE statement to group the accounts. What is the most efficient way to accomplish this task. i could write individual expressions but I imagine there is a better way.

WagesBenefits = CALCULATE(sum(GenJournalDetail[AccountValue]),
    GenJournalDetail[Department]>="604",
    GenJournalDetail[Department]<="999",
    GenJournalDetail[Account]>="60350",
    GenJournalDetail[Account]<="60450" ||
    GenJournalDetail[Account]>="60160",
    GenJournalDetail[Account]<="60225"||
    GenJournalDetail[Account]="60500" ||
    GenJournalDetail[Account]="60550" ||
    GenJournalDetail[Account]="60575" ||
    GenJournalDetail[Account]="60600" ||
    GenJournalDetail[Account]="60625" ||
    GenJournalDetail[Account]="60650"
 )

Thank you!

[parry2k · Accepted solution]

@dgjacobson I would recommned to add a calculated field wiith condition to return 1 or 0 (true or false) andt hen in your measure use that column to filter the accounts.

This way you will able to put this logic in other measures as well using calculated column instead of writing this whole filter condition in measure.

[dgjacobson]

@parry2k: Thanks! Simple solution but it works! ... whish I'd thought of it 🙂

I modified it slightly by creating  a few columns with natural account groups. Then my initial condition begins with an account group, eiliminating the filtering. I can then add the additional account filters if necessary. After a lot of experimentation, I found that I can add one account set that is a range defined by a >= and <= and as many indvidual account filters as necessary. But, if I try and include two conditions with a range in the same expression, it does not work. Easy to work around that though.

Thanks again.