Forum Discussion

IgorM's avatar
IgorM
Frequent Visitor
2 years ago

Measure value for first item only

Hi,   I need to create a  measure that returns value for the first row with a given order. The source data is as follows: SOURCE DATA Order No DN# Order Total Weight 1383130672 MK0Q3L...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

 

I mean the first row/occurence of a given Order No

 

DAX has no concept of that "first occurrence"  - you need to bring your own index column (or other logic), same like I showed for Power Query.

IgorM's avatar
IgorM
Frequent Visitor
2 years ago

Hi Ibendlin,

 

I realise that DAX has no concept of row ordering but for the purpose of this query to identify the first row for a given Order No I was thinking of using the RANK function.

 

Regards,

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    There is also a ROWNUMBER function but the same caveat applies - it is non-deterministic.