DAX measure help multiple measures referenced in a table not working

[Dusenberrytw]

I am trying to recreate an excel based spread sheet in Power BI. I do not want to use any calculated columns because some of the measures rely on a selected value and I do not want to have to refresh all the time to get the solution. When I display the data in a table and filter it to the that I want, everything works except this measure:

MADJ AAD = ABS([MADJ Ratio]-[MADJ Median]).

The supporting measures are as follows:

MADJ Ratio = DIVIDE([MADJ Value], SUM('Improv_W_Count&LEA'[SALEPRICE]),0)*100

MADJ Value =
SUMX(
'Improv_W_Count&LEA',[House Value] * SELECTEDVALUE('Market Adjustment 2'[Market Adjustment])
+ 'Improv_W_Count&LEA'[CURRENT YEAR LANDVALUE])

House Value =
SUM('Improv_W_Count&LEA'[TOTALVALUE])-SUM('Improv_W_Count&LEA'[CURRENT YEAR LANDVALUE])

MADJ Median = MEDIANX(VALUES('Improv_W_Count&LEA'[ACCOUNTNO]), [MADJ Ratio])

[Dusenberrytw]

Pbix 

Sample Data Set added.

[lbendlin · Accepted solution]

MADJ AAD = ABS([MADJ Ratio]-CALCULATE([MADJ Median],ALLSELECTED()))

[lbendlin]

Forget that this came from Excel.  Describe what you are trying to achieve.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...