Any chance you can share packaged workbook or some screenshots of what you have set up?
Without seeing your workbook, this is difficult to answer, but perhaps you can try adding your filter to context Just right click on the pill and select "Add to context"
Step 1: Click on the ID and Select sort
Step 2: Select Descending and Sort by Field ans Select the field as "Measure" and aggregation would be sum
Step 3: Click ok eventhough you change the filter your sort wont break
Before applying Filter
After applying filter
Hope this helps
Mark this answer as complete or helpful so that it helps