Forum Discussion

aherabit's avatar
aherabit
Icon for Helper I rankHelper I
2 years ago
Solved

lookup same table for referenced field values

Hi Folks, I have a problem with looking the same table and capturing its values for referenced field values.   Here is my data table: data table issue id abstract related_issue_id x-123 ...
  • vicky_'s avatar
    vicky_
    2 years ago

    Try the following DAX:

    abstract related issue = CALCULATE(MIN('Table'[abstract]), ALL('Table'), TREATAS(VALUES('Table'[related_issue_id]), 'Table'[issue id]))

     

vicky_'s avatar
vicky_
Icon for Super User rankSuper User
2 years ago

Try the following DAX:

abstract related issue = CALCULATE(MIN('Table'[abstract]), ALL('Table'), TREATAS(VALUES('Table'[related_issue_id]), 'Table'[issue id]))

 

aherabit's avatar
aherabit
Icon for Helper I rankHelper I
2 years ago

thank you very much!