Returns only first row with lookupvalue

[Laufer_Israel]

Hi all,

I have a table as can be seen below and I would like to see only the first row for "Total sales 2018" column.

It is important to note that "Total sales 2018" is a data which has been taken from another table with LOOKUPVALUE DAX.

Does it is possible to see only the first row for each customer?? (in order to avoid duplication)

Many thanks in advance.

Code	Name	Product	Quantity	Total sales 2018
1	One	PP	2	220
1	One	SS	3	220
1	One	YY	4	220
1	One	MM	9	220
2	Two	PP	1	167
2	Two	SS	4	167
2	Two	YY	7	167
2	Two	MM	2	167
3	Three	PP	3	701
3	Three	SS	1	701
3	Three	YY	3	701
3	Three	MM	8	701