Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
aherabit
Helper I
Helper I

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 idabstractrelated_issue_id
x-123abstract-x123y-543
x-234abstract-x234 
x-654abstract-x654 
y-543abstract-y543x-123
y-657abstract-y657 

 

 

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

(desired output)

issue idabstractrelated_issue_idabstract_related_issue
x-123abstract-x123y-543abstract-y543
x-234abstract-x234  
x-654abstract-x654  
y-543abstract-y543x-123abstract-x123
y-657abstract-y657  

 

Thank you very much for any help.

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

Try the following DAX:

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

 

View solution in original post

3 REPLIES 3
vicky_
Super User
Super User

Try the following DAX:

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

 

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?

thank you very much!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.