Get the median based on certain column

Hello im trying to compute median of the market value (MV) for each of site based on municipality which the site is located, and if there is no record of MV for the particular municipality, get the median based on the province which the site is located. 

I have 3 tables:

LGU list has one to many relationship with SID using LGU Code, wile SID has one to many relationship with Consolidated TD List using site ID.
I tried to come up with a measure like this:

Median Measure = 
VAR MedMun=
CALCULATE(
    MEDIAN('Consolidated TD List'[MV]),
    'Consolidated TD List'[TDNo] <> BLANK(),
    CONTAINSSTRING('Consolidated TD List'[Property Type], "Building"),
    REMOVEFILTERS('LGU List'[LGU Code]),
    VALUES('LGU List'[Municipality])
)
VAR MedProv =
CALCULATE(
    MEDIAN('Consolidated TD List'[MV]),
    'Consolidated TD List'[TDNo] <> BLANK(),
    CONTAINSSTRING('Consolidated TD List'[Property Type], "Building"),
    REMOVEFILTERS('LGU List'[LGU Code]),
    VALUES('LGU List'[Province])
)
RETURN
IF(
    MedMun>0,
    MedMun,
    MedProv
) 

Somehow it is not working. My visual is a simple one, list of site ids and the median, with grandtotal. Let me know what needs to change. Thanks