DAX- Multi-Filtering criteria (A AND B) OR (C AND D)

[Anonymous]

Dear Experts,

In DAX i need to filter with condition account operation group (A & B) OR account operation group (C & D).

But, the codding doesn't seems working. Could you advise me how to fix this DAX codding? Many Thanks in Advance.

Measure = CALCULATE([USDAmount],FILTER(FILTER(Account, Account[AccountGroup]="A"|), FILTER('Operation Report','Operation Report'[OperationReportAccount]="B")) || FILTER(FILTER(Account, Account[AccountGroup]="C"|), FILTER('Operation Report','Operation Report'[OperationReportAccount]="C")).

Account group & operation report account are from differerent column & different table (1 from account, 1 from operation report).

Let me know if you have any idea on this.

Many thanks 😉

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my test, you could refer to below formula:

Sample data:

Create a calculated table:

Table = CALCULATETABLE('Table1',FILTER(Table1,OR(Table1[AccountGroup]=41 && Table1[OperationReportAccount]=197,(Table1[AccountGroup]=47 && Table1[OperationReportAccount]=198))))

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

[LivioLanzo]

Hi @Anonymous

are you able to post a sample of your tables? thx

[Anonymous]

@LivioLanzo Hi Livio, below is the table example.

I need to filter USDAmount column only for (Account Group= 41 - AND - Operation Report Account=197) OR (Account Group 47- AND- OperationReportAccount =198)

Please advise me the DAX coding. I have tried coding as per my prev. post but it doesn't work.

Thanks,

[PattemManohar]

@Anonymous Please try to post the sample data in copiable format. I guess you are looking for subset of this table based on the filter criteria mentioned. Please try this as a "New Table"

NewSubset = FILTER(TableName,OR((TableName[AccountGroup]=41 && TableName[OperationReportAccount]=197),(TableName[AccountGroup]=47 && TableName[OperationReportAccount]=198))