Forum Discussion
Laufer_Israel
Helper I
Helper IReturns only first row with lookupvalue
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 ...
Laufer_IsraelHelper I
Helper IThe right column it is what I am looking for.
| Code | Name | Product | Quantity | Total sales 2018 | Total sales 2018 |
| 1 | One | PP | 2 | 220 | 220 |
| 1 | One | SS | 3 | 220 | |
| 1 | One | YY | 4 | 220 | |
| 1 | One | MM | 9 | 220 | |
| 2 | Two | PP | 1 | 167 | 167 |
| 2 | Two | SS | 4 | 167 | |
| 2 | Two | YY | 7 | 167 | |
| 2 | Two | MM | 2 | 167 | |
| 3 | Three | PP | 3 | 701 | 701 |
| 3 | Three | SS | 1 | 701 | |
| 3 | Three | YY | 3 | 701 | |
| 3 | Three | MM | 8 | 701 |
Hi Laufer_Israel ,
Are you able to this kind of lookup? I yes. May I know please what DAX did you use?
Thank you 🙂