I'm still struggling with some of the PowerBI basics, so don't be surprised if I'm trying to do things in a weird or unorthodox way. Yet i need to move forward and I'm really trying my best. Any sort of help, advice or solutions to the problem are appreciated. As a disclaimer, I know Direct Querrying exists but I can't seem to make it useful in my case.
I'm currently trying to load in a view or procedure that should have a dynamic paramter for it's where statement. This parameter shouldn't be decided upon connecting to the DB source but rather upon selecting an article in a table. Actually, this is just the way I'm trying to make stuff work since I can't think of another way for it to work, so the solution might be for me to redo the whole thing in another way.
My case is as followed: I have customers who buy articles with different distributors. I know which price they pay per article but the same article could be bought with another distributor for a different price. I'm trying to figure out the minimum or maximum paid price, which I made work bu using some scalar-valued functions. However, now I'm comparing every customer, yet some fall in a different category. For example, we have the customer type (hotel) and the customer size (big). I need to make sure I only compare big hotels and therefore the only solution I can think of is to edit my views/procedures with a where statement. Again, I can only know which where-statement should be taken upon selecting an article (which falls under a customer)
As an example, this is what I was able to cook up so far (Can't seem to upload images):
https://i.imgur.com/K9a5wm5.png
Off course, the above case isn't the only one I'm struggling with. For example, same goes for getting the top 50 articles for a customer (I do this with a view, which needs the customer parameter). I've been searching the web and I've found and tried functions like TOPN and RANKX but still can't get it to work... and yes, the list goes on and I feel lost
