Does this do what you are after?
Income Variance Due to Died :=<br><span class="Keyword" style="color:#0070FF">SUMX</span><span class="Parenthesis" style="color:#969696"> (</span><br><span class="indent4"> </span><span class="Keyword" style="color:#0070FF">VALUES</span><span class="Parenthesis" style="color:#969696"> (</span> Dates[MonthName] <span class="Parenthesis" style="color:#969696">)</span>,<br><span class="indent4"> </span><span class="Keyword" style="color:#0070FF">CALCULATE</span><span class="Parenthesis" style="color:#969696"> (</span><br><span class="indent8"> </span><span class="Keyword" style="color:#0070FF">SUM</span><span class="Parenthesis" style="color:#969696"> (</span> Fee_Analysis[Fee] <span class="Parenthesis" style="color:#969696">)</span>,<br><span class="indent8"> </span><span class="Keyword" style="color:#0070FF">CALCULATETABLE</span><span class="Parenthesis" style="color:#969696"> (</span><br><span class="indent8"> </span><span class="indent4"> </span><span class="Keyword" style="color:#0070FF">VALUES</span><span class="Parenthesis" style="color:#969696"> (</span> Fee_Analysis[Member ID] <span class="Parenthesis" style="color:#969696">)</span>,<br> Fee_Analysis[Died_Flag] = <span class="Number" style="color:#EE7F18">1</span><br><span class="indent8"> </span><span class="Parenthesis" style="color:#969696">)</span>,<br><span class="indent8"> </span><span class="Keyword" style="color:#0070FF">DATEADD</span><span class="Parenthesis" style="color:#969696"> (</span><br> Dates[Date],<br><span class="indent8"> </span><span class="indent4"> </span><span class="Number" style="color:#EE7F18">-1</span>,<br><span class="indent8"> </span><span class="indent4"> </span><span class="Keyword" style="color:#0070FF">MONTH</span><br><span class="indent8"> </span><span class="Parenthesis" style="color:#969696">)</span><br><span class="indent4"> </span><span class="Parenthesis" style="color:#969696">)</span><br><span class="Parenthesis" style="color:#969696">)</span><br>
Income Variance Due to Resigned :=<br><span class="Keyword" style="color:#0070FF">SUMX</span><span class="Parenthesis" style="color:#969696"> (</span><br><span class="indent4"> </span><span class="Keyword" style="color:#0070FF">VALUES</span><span class="Parenthesis" style="color:#969696"> (</span> Dates[MonthName] <span class="Parenthesis" style="color:#969696">)</span>,<br><span class="indent4"> </span><span class="Keyword" style="color:#0070FF">CALCULATE</span><span class="Parenthesis" style="color:#969696"> (</span><br><span class="indent8"> </span><span class="Keyword" style="color:#0070FF">SUM</span><span class="Parenthesis" style="color:#969696"> (</span> Fee_Analysis[Fee] <span class="Parenthesis" style="color:#969696">)</span>,<br><span class="indent8"> </span><span class="Keyword" style="color:#0070FF">CALCULATETABLE</span><span class="Parenthesis" style="color:#969696"> (</span><br><span class="indent8"> </span><span class="indent4"> </span><span class="Keyword" style="color:#0070FF">VALUES</span><span class="Parenthesis" style="color:#969696"> (</span> Fee_Analysis[Member ID] <span class="Parenthesis" style="color:#969696">)</span>,<br> Fee_Analysis[Resigned_Flag] = <span class="Number" style="color:#EE7F18">1</span><br><span class="indent8"> </span><span class="Parenthesis" style="color:#969696">)</span>,<br><span class="indent8"> </span><span class="Keyword" style="color:#0070FF">DATEADD</span><span class="Parenthesis" style="color:#969696"> (</span><br> Dates[Date],<br><span class="indent8"> </span><span class="indent4"> </span><span class="Number" style="color:#EE7F18">-1</span>,<br><span class="indent8"> </span><span class="indent4"> </span><span class="Keyword" style="color:#0070FF">MONTH</span><br><span class="indent8"> </span><span class="Parenthesis" style="color:#969696">)</span><br><span class="indent4"> </span><span class="Parenthesis" style="color:#969696">)</span><br><span class="Parenthesis" style="color:#969696">)</span><br>