How to get Max of column wrt two Filters?

[Anonymous]

Table	NP ID	Provider Full Name	Drug	Market Share Numerator	Market Share Denominator	Expected Output
PROD	130928288	Pentakota Jagadeesh	Xamorin	51392	0	0.570819266
PROD	130928288	Pentakota Jagadeesh	Xamorin	0	0	0.570819266
PROD	130928288	Pentakota Jagadeesh	Xamorin	0	90032	0.570819266
PROD	130928288	Pentakota Jagadeesh	Xamorin	0	0	0.570819266
PROD	130928288	Pentakota Jagadeesh	Xamorin	0	0	0.570819266
PROD	130928288	Pentakota Jagadeesh	Remora	0	0	1
PROD	130928288	Pentakota Jagadeesh	Remora	0	35061	1
PROD	130928288	Pentakota Jagadeesh	Remora	35061	0	1
PROD	130928288	Pentakota Jagadeesh	Remora	0	0	1
PROD	130928288	Pentakota Jagadeesh	Remora	0	0	1
PROD	123456788	Vinay kumar	Aftarimin	0	0	1
PROD	123456788	Vinay kumar	Aftarimin	0	69330	1
PROD	123456788	Vinay kumar	Aftarimin	69330	0	1
PROD	123456788	Vinay kumar	Aftarimin	0	0	1
PROD	123456788	Vinay kumar	Aftarimin	0	0	1
PROD	123456788	Vinay kumar	Aftarimin	0	0	1
Channel	190308883	Santosh babu	Dolo65	0	0	4
Channel	190308883	Santosh babu	Dolo65	100	0	4
Channel	190308883	Santosh babu	Dolo65	0	25	4

Above is my Data Model and i was looking for the Dax Query to get my output as Column called "Expected Output" in the Above Table.

The output should be Max of (Market Share Numerator)/ Max(Market Share Denominator) wrt Drug for PROD Table

NPI ID is Unique for every provider 

[rfigtree]

=CALCULATE(
	DIVIDE(MAX(Table1[Market Share Numerator]),MAX(Table1[Market Share Denominator])),
	ALLEXCEPT(Table1,Table1[NP ID],Table1[Drug]))