Filter measure multiple tables and columns

[sanderson82]

Hi, read a few posts on this but can't find exactly what I need.  I'm creating a measure which will be used in another calculation.  The inital measure I am creating needs to be filtered based on values in other tables.

Below is my measure working with a couple of filters

TotalTransport = CALCULATE(

SUM(PCProjectEntry[GoodsAmountInBaseCurrency]),

FILTER(PCProjectEntryDescriptor,PCProjectEntryDescriptor[Name]="Purchase Invoice"),

FILTER(PCProjectItem,PCProjectItem[Code]="Transport")

I also want filter by PCProjectEntryDescriptor[Name]="Purchase Credit" and in addtion filter by more than one PCProjectItem[Code].

Is it possible to have mulitple filters in one line? eg PCProjectEntryDescriptor[Name]="Purchase Invoice" && "Purchase Credit".....something like that, or does each item require a filter statement regardless if it's in the same table or not?

Many thanks

[TeigeGao · Accepted solution]

Hi @sanderson82 ,

In your scenario, we can use the RELATED() funtion and && to write the DAX query:

TotalTransport = CALCULATE(
SUM(PCProjectEntry[GoodsAmountInBaseCurrency]),
FILTER(PCProjectEntryDescriptor,PCProjectEntryDescriptor[Name]="Purchase Invoice"),
FILTER(PCProjectItem,PCProjectItem[Code]="Transport" && RELATED(PCProjectEntryDescriptor[Name])="Purchase Invoice")

Best Regards,

Teige