Hi Elie Rahi ,
Yes ,you cant use LOD with multiple data source or blended data .In order to overcome this you can use table calculation .
I am sharing one old thread for the same issue ,please have a look .And in case you face any issue please revert .
Please mark it right and helpful if this serves your purpose ,so that others can also get benefited .
Hi Nikher, I did have a look at this thread before posted the question, but was too confusing and unsure what to do...