Forum Discussion

nemo189's avatar
nemo189
Frequent Visitor
2 years ago

OLE DB error

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.

Need Help
Tips and Tricks

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    2 years ago

    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's avatar
      nemo189
      Frequent Visitor
      2 years ago

      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.