It's difficult to understand the whole story only from screenshots, but maybe LOD can help?
Is there anyway that LOD expressions can be used a quick filter? So that the user can select how much to invest rather than showing just the max value? A slider or input from a parameter
I'm not all familiar with them
Yes, your question is quite general.
You can go to official training Video or official BKM site which Tableau provides to start with.