Memory Error

[NimaiAhluwalia]

I have 2 tables with 2M rows each and joined with a key column made in Power Query by concatenating multiple columns of the table and creating a 1-1 relationship.

When I created logic in a measure it was working well but when I updated it as the client's requirement got changed i got the below error.

I tried various ways to optimise the dax and the model but it was not enough, then I tied to see the bottleneck in the dax so I used DAX studio and tried to find the issue as shown below but was not able to understand much as in which line of code is hampering my performance.

Dax code

I feel the EU mat others is the one which is causing the delay because the above code works fine without it

@amitchandak 
@grey 
@Syndicate_Admin 
@Greg_Deckler 
@parry2k 
@Fowmy 
@selimovd 

Regards

[parry2k]

@NimaiAhluwalia it is very hard to answer what is going on? Maybe it will be easier if you put together a pbix file with sample data and share it here. DAX expression only cannot tell anything, you should also share a relationship diagram, although your dataset is very small and I don't see that is an issue.

It will be also good to know what you are trying to achieve, I see there are a lot more ifs, etc.