Have a question regarding using both power pivot and pivot table together

Question

Please see attached screenshot:
I have 1 regular table, power pivot data model, power pivot table
I suspect I wrote the wrong measures for what I wanted to achieve.

This is my measure: Current total$:=SUMX(DISTINCT(Table1[CURRENT]),SUM([Sales$]))
The pivot table shows the current total $ for Sarah is 400, however I thought my measure has put a filter on "current", that SARAH is not on the current list, so for Sarah, the sales should be 0.

How do I modify the measure or add one to get 0 for Sarah's current total?

Answer 1

Excel 365 Pro Plus with Power Pivot and Power Query.
With PQ Append().
https://www.mediafire.com/file/w3wcewu3lw1w7h5/01_01_23.xlsx/file
https://www.mediafire.com/file/texgrssre7vgnha/01_01_23.pdf/file