Select and _Thisrow not working

[cjpm74]

Good day,
I want to sum the values ​​of the column (ROI) in the table "arbitraje" in another table "summary" IF I use this expression "SUM(SELECT(arbitraje[ROI],[_thisrow].[Crypto]= [Crypto]))" the result is zero, but on the original tables it´s work.

Thanks for your time

[lynchk21 · Accepted solution]

It looks like you have these set up with a reference between the Summary table and the arbitraje table with a reference between Summary[ID] and andarbitraje[cripto]. In this case you should have a REF_ROW column called [Related arbitrajes]. You should be able to use:

• SUM([Related arbitrajes][ROI])

If that is not the case, it seems like your SELECT() should be 

• SUM(SELECT(arbitraje[ROI],[cripto]=[_thisRow].[ID]))

[lynchk21 · Accepted solution]

It looks like you have these set up with a reference between the Summary table and the arbitraje table with a reference between Summary[ID] and andarbitraje[cripto]. In this case you should have a REF_ROW column called [Related arbitrajes]. You should be able to use:

• SUM([Related arbitrajes][ROI])

If that is not the case, it seems like your SELECT() should be 

• SUM(SELECT(arbitraje[ROI],[cripto]=[_thisRow].[ID]))

[cjpm74]

---

@lynchk21 wrote:

If that is not the case, it seems like your SELECT() should be 

• SUM(SELECT(arbitraje[ROI],[cripto]=[_thisRow].[ID]))

---

Thank you for your time, indeed this structure made the data display correctly. I reiterate my thanks, cheers!

[Trevwiller · Accepted solution]

Hello cjpm74, I'm glad your issue got solved. Would you be able to mark lynchk21's response as the solution so if other users have the issue they can find it easier.