PRODUCT and VLOOKUP in DAX power bi

[mrcss23]

Hi. I have imported two tables in power BI.

Table 1 has values for several employes.

Table 2 has a rate for each employee.

I would like to SUM the result of product VALUE (table 1)* Rspective RATE (table 2).

In Excel I use PRODUCT and VLOOKUP,

The final result should be total of that column (126, 91 in the example below)

What should be the DAX in POWER BI?

Thank you!

[mrcss23 · Accepted solution]

I just found a way!!!

Result = SUMX('Table 1','Tavle1'[VALUE]*RELATED('Table 2'[Rate]))

[Greg_Deckler]

@mrcss23 There is an equivalent PRODUCT function in DAX, although you can just use *. Also there is PRODUCTX. For VLOOKUP either use LOOKUPVALUE or MAXX(FILTER(...),...)

[mrcss23]

I know the fuctions but I am not being able to achieve the result. Any suggestion?