topic Re: lookup same table for referenced field values in DAX Commands and Tips

lookup same table for referenced field values

aherabit — Tue, 28 Nov 2023 20:27:18 GMT

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

I would like to capture the 'abstract' field values for all related_issues to produce the following visual/table:

(desired output)

Thank you very much for any help.

vicky_ — Tue, 28 Nov 2023 22:23:04 GMT

Try the following DAX:

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

aherabit — Tue, 28 Nov 2023 23:18:36 GMT

thank you very much!

aherabit — Wed, 13 Dec 2023 00:41:05 GMT

Hi Vicky.

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

from the following data source:

Could you lend a hand?