Filter on different tables

[Kpham]

Dear PBI expert,

I need to calculate the turnover and therefor I need to filter the turnover based on attributes from two different tables. The tables all have a relationship with eachother. But I can't figure out how to make this measure. I tried two different ways, but don't get the right result. Can somebody tell me how you can filter on different tables.

Measure2 = CALCULATE(SUM('SD SalesDocumentLines'[Net Value in EUR]),
    FILTER( 
                'SD SalesDocumentLines',[Account Assignment Group Material] ="R4"),
    FILTER(
                'MD SalesDocumentTypes',[Sales Document Type  Code] = "ZSPR"))

Measure = CALCULATE(SUM('SD SalesDocumentLines'[Net Value in EUR]),
    FILTER( 
            crossjoin(
                ALL('SD SalesDocumentLines'[Account Assignment Group Material]),
                ALL('MD SalesDocumentTypes'[Sales Document Type  Code])
                ),
                [Account Assignment Group Material]="R4" ||
                [Sales Document Type  Code] = "ZSPR" 
    )
)

[lbendlin]

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.