Countrows by filtering two tables

[CarlsBerg999]

Hi,

I have two tables. I have a measure to count rows based on date and status. I need to add another filter to a related table (i have set up a relationship with an ID). It needs to filter values where status in table 2 is also "Open". How do i add another filter to this measure that also applies the filter from another related table? 

Measure 1 = COUNTROWS(

FILTER('Table1', [Invoice Date] <= today()

&& [Status] = "Open"))+0

Thanks for the help!

[jdbuchanan71 · Accepted solution]

@CarlsBerg999 

Give this a try

measure1 =
CALCULATE (
    COUNTROWS (
        FILTER ( 'Table1', [Invoice Date] <= TODAY () && [Status] = "Open" )
    ),
    'Table2'[Field] = "something"
)