How to calculate with unrelated tables

[jvrnicfi]

community help needed

I have two table, one is "data" and other is "guide".
"result" table is answer what i need

What i need is amount SUM when data table account is between guide table TVTIAL and TVTILO ?

Simple solution, something like this: 

CALCULATE(
SUM(DATA[amount]),
FILTER(DATA[account] >= GUIDE[TVTIAL] && DATA[account] <= GUIDE[TVTILO])
)

of course the above doesn't work

What is the right way to solve it?

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

EUROT measure: =
IF (
    HASONEVALUE ( Guide[RIVINRO] ),
    SUMX (
        FILTER (
            Data,
            Data[Account] >= MAX ( Guide[TVTIAL] )
                && Data[Account] <= MAX ( Guide[TVTILO] )
        ),
        Data[Amount]
    ) * -1 + 0
)