Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 | abstract-x123 | y-543 |
x-234 | abstract-x234 | |
x-654 | abstract-x654 | |
y-543 | abstract-y543 | x-123 |
y-657 | abstract-y657 |
I would like to capture the 'abstract' field values for all related_issues to produce the following visual/table:
(desired output)
issue id | abstract | related_issue_id | abstract_related_issue |
x-123 | abstract-x123 | y-543 | abstract-y543 |
x-234 | abstract-x234 | ||
x-654 | abstract-x654 | ||
y-543 | abstract-y543 | x-123 | abstract-x123 |
y-657 | abstract-y657 |
Thank you very much for any help.
Solved! Go to Solution.
Try the following DAX:
abstract related issue = CALCULATE(MIN('Table'[abstract]), ALL('Table'), TREATAS(VALUES('Table'[related_issue_id]), 'Table'[issue id]))
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:
defect | epic | epic description | requirements |
s-2 | s-20 | description s-20 | s-101 |
s-18 | s-15 | epic description s-15 | s-3, s-4 |
s-205 | s-15 | epic description s-15 | s-101 |
from the following data source:
issue key | type | description | epic link |
s-2 | defect | defect description s-2 | s-20 |
s-3 | requirement | requirement description s-3 | s-15 |
s-4 | requirement | requirement description s-4 | s-15 |
s-15 | epic | epic description s-15 | |
s-18 | defect | description s-18 | s-15 |
s-20 | epic | description s-20 | |
s-101 | requirement | description s-101 | s-20 |
s-205 | defect | description s-201 | s-15 |
Could you lend a hand?
thank you very much!
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
10 | |
6 |