Counting a column based on a filter from another column

Hi Community,

I have two tables.

Table A:

TABLE B:

The two tables have been joined by Student# and Sibling # having many to many relationship.

(There are also other columns in the tables but have not been included for the sake of simplicity and they are not of my interest for this required calculation).

What I want is Count Distinct Student# in Table A where Status = Active.

I simply used a table visual, dragged Student# and selected Count(Distinct) for
Student#. Applied filterd 'Status' on the visual for 'Active'.

Expected result:

DistinctCount of Student#: 2

(As for Student# 1,there's only 1 sibling 'S2' in Table B which is Inactive. so this shouldn't be counted.

My Result:
DistinctCount of Student#: 3

In-fact, I want to get equivalent of the following sql to get my expected result:

select distinct count(Student#) from TABLEA a

inner join TABLEB b on

a.Student# = b.Student# and

a.Sibling# = b.Sibling#

where b.Status = 'Active'

(This query results count of 2)

I tried this DAX too

Studentcoutn = CALCULATE(COUNT('TABLEA'[STUDENTNUMBER]),FILTER('TABLEB','TABLEB'[STATUS]="Active"))

This is also not working.

Please advise.

Thanks in advance!