OLE DB error

[nemo189]

I have been trying to run this measure , however its giving OLE DB memmory issue .I tried some methods but everytime i am getting this issue.

method 1 :
Measure = CALCULATE(
IF ( 
    MAX('Purchase Order Line'[End Date Time]) <= TODAY(), 
    0, 
    IF ( 
        ('Purchase Details'[Received Amount]) = 0,
        0,
        ('Purchase Details'[Received Amount]) - ('Purchase Details'[Billed Amount])
    ) 
))

Method 2:
Measure = 
Switch(
   True(),
   MAX('Purchase Order Line'[End Date Time])<=TODAY(),0,
    'Purchase Details'[Received Amount] = 0,0,
     TRUE(),'Purchase Details'[Received Amount] - 'Purchase Details'[Billed Amount]
)

Please Help. Thankyou.

[BA_Pete]

Hi @nemo189 ,

Can you provide some further info please:

-1- An example of the data in each of the tables referenced in your measure.

-2- Number of rows are in each of these tables.

-3- Any relationships that affect these tables and the cardinality (1:1, 1:Many etc.).

Thanks,

Pete

[nemo189]

cardinality is 1:many bidrectional . purchase order line(1): purchase details(many).
purchase order line has 4.5million rows, and purchase details has 7.5 million rows.
Running in direct query mode. Its saying needed memory is 1038, limit is 1024.