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

Hi Vicky.

If we expand on the solution by caluclating the following output:

defectepicepic descriptionrequirements
s-2s-20description s-20s-101
s-18s-15epic description s-15s-3, s-4
s-205s-15epic description s-15s-101

 

from the following data source:

issue keytypedescriptionepic link
s-2defectdefect description s-2s-20
s-3requirementrequirement description s-3s-15
s-4requirementrequirement description s-4s-15
s-15epicepic description s-15 
s-18defectdescription s-18s-15
s-20epicdescription s-20 
s-101requirementdescription s-101s-20
s-205defectdescription s-201s-15

 

Could you lend a hand?