Adding functions with parameters from different tables

After adding a Scalar-valued Function from my database, I try and call this function but am unable to fill in the parameters as requested. I can only select the columns of the table selected when adding the function. No other columns can be used.

Screenshot with the described step (Dutch): https://imgur.com/a/KpbWle9

I have to pass columns from different tables for my function to work, is this possible?

If not, how can I transform a regular SQL-statement containing JOINS and WHEREs to a DAX-statement?

The SQL-statement:

SELECT @MinMaxValue = MIN(FactPrijs)
FROM ArtikelM
INNER JOIN Leverancier
    ON ArtikelM.LevId = Leverancier.LevId
INNER JOIN Klanten
    ON ArtikelM.KlantenId = Klanten.KlantenId
WHERE ArtikelId = @ArtikelId
    AND Klanten.KlantTypeCategorie = @KlantType
    AND Klanten.KlantGrootteCategorie = @KlantGrootte