Querry SQL View or Procedure with dynamic parameter

Thank you for taking the time to read over and answer the question. However, I don't see the option to use a dynamic paramter (chosen from the visual) in the subquery. How would one do this?

After searching some more and taking your suggestion in consideration, I managed to follow this link: https://community.powerbi.com/t5/Desktop/Subquery/m-p/319059/highlight/true#M141971 to https://www.sqlbi.com/articles/from-sql-to-dax-filtering-data/ where it would seem that I can use a filter to devide my customers in categories. However, some way of dynamically adding a parameter (to filter) seems nescecary in my case.

I've been able to add parameters with functions, yet can't do this with views or procedures.

Maybe I'm just having trouble understanding the concept..

Or maybe some sort of DAX function where I translate my procedure/view into DAX, which will enable me to use my slicers without the need of dynamic parameters.