Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Issue | Name of Parent Issue | Hours |
A-1 | 1 | |
A-2 | 2 | |
B-1 | 3 | |
B-2 | 4 | |
B-3 | 5 | |
B-22 | B-2 | 6 |
B-33 | B-3 | 7 |
C-1 | 8 | |
D-1 | 9 | |
E-1 | 10 |
Solved! Go to Solution.
You can create a mapping table like below and create relationship with your table, and then below mapping table will work like Level1 and Level2. Hope this helps.
Issue | Name of Parent Issue |
A-1 | A-1 |
A-2 | A-2 |
B-1 | B-1 |
B-2 | B-2 |
B-3 | B-3 |
B-22 | B-2 |
B-33 | B-3 |
C-1 | C-1 |
D-1 | D-1 |
E-1 | E-1 |
or, if you dont want to go that route; this measure should give you what you want:
TotalHours =
var currentIssue = SELECTEDVALUE(issues[Issue])
var isParent = if(not(isblank(lookupvalue(issues[Name of Parent Issue],issues[Name of Parent Issue],currentIssue))),1,0)
var parentHours = calculate(sum(issues[Hours]),filter(all(issues),currentIssue=issues[Name of Parent Issue]))
var issueHours = calculate(sum(issues[Hours]))
return
if(isParent, parentHours+issueHours ,issueHours)
You can create a mapping table like below and create relationship with your table, and then below mapping table will work like Level1 and Level2. Hope this helps.
Issue | Name of Parent Issue |
A-1 | A-1 |
A-2 | A-2 |
B-1 | B-1 |
B-2 | B-2 |
B-3 | B-3 |
B-22 | B-2 |
B-33 | B-3 |
C-1 | C-1 |
D-1 | D-1 |
E-1 | E-1 |
That's true. Thanks. But what if I would like to see the hours that correspond to each of them (B-2 and B-22)?
@J_o_n_a_s ,
The you can just pull the original column(Issue).
What is you expected result? Can you provide it in tabular format?
Hi @J_o_n_a_s ,
You can simple create a new column and use that.
DAX of new column:
New Issue = IF('Table'[Name of Parent Issue]=BLANK(),'Table'[Issue],'Table'[Name of Parent Issue])
Image Reference:
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |