Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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 !!!
User | Count |
---|---|
84 | |
82 | |
66 | |
52 | |
46 |
User | Count |
---|---|
100 | |
48 | |
42 | |
39 | |
38 |