Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 !!!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
112 | |
98 | |
98 | |
92 |