DISTINCT TABLE USING DAX MEASURES

I have a file named receipt data with duplicates receipt no. Sample data

I know that we can remove duplicates using power query – simple step.

But I cannot perform the simple step due to the large data model.

I compared the query loading to data model with and without removing duplicates.

It takes hell lot of time when the data is loaded to power query after removing duplicates in power query.

Data loads faster if removing duplicates steps not performed in power query.

So after loading the receipt data containing duplicates in power pivot, I created a distinct table with unique receipt no.

Now I don’t know how to get the additional columns of receipt data in the distinct table. I tried to do with related function but it does not work.

Output required.