Forum Discussion
Unable to figure this problem out
Anonymous Might help although I do not think I have included MM3TR&R yet which is kind of what you are looking for. Try something like below. Basically at the "group" level (first hierarchy level) you are going to have multiple Tasks. So, if you have only a single Task, then you are at the second level of the hierarchy, otherwise, you are at the top level of the hierarchy. This uses HASONEVALUE instead of ISINSCOPE but same concept.
Measure = IF( HASONEVALUE('Tasks'[ISSUE_KEY]), MAX('Tasks'[SUMMARY]), MAX('Epics'[SUMMARY]) )
| PARENT_ISSUE_KEY | ISSUE_KEY | SUMMARY | ISSUE_STATUS | done |
| CAPLO-1 | CAPLO-16 | This is just text so | New | 0 |
| CAPLO-1 | CAPLO-17 | Another text field | In Progress | 0 |
| CAPLO-1 | CAPLO-18 | yet another text | Done | 1 |
The above is from the Tasks table
The below is from Epics
| PARENT_ISSUE_KEY | ISSUE_KEY | Summary | Status | Done |
| RMPP-1 | CAPLO-1 | different text based on epic | New | 0 |
| RMPP-2 | CAPLO-2 | text based on epic | In progress | 0 |
| RMPP-2 | CAPLO-3 | text based on epic | done | 1 |
So, as you can see 2 different table containing different information, but with the PARENT_ISSUE_KEY being the link between Tasks and Epics
What I would like to see is:
| PARENT_ISSUE_KEY | ISSUE_KEY | Summary | Status |
| CAPLO-1 | Epic summary | epic status | |
| CAPLO-16 | Task summary | task status | |
| CAPLO-17 | Task Summary | task status |
As you can see from the pictures i shared earlier, the + sign opens the information about the tasks.
- Greg_Deckler
Community Champion
Anonymous So, use ISINSCOPE in your measure to determine where you are in the hierarchy and then return either the Epics status or the Task status as appropriate. I assume the tables are related on ISSUE_KEY in Epics to PARENT_ISSUE_KEY in Tasks. Use the ISSUE_KEY from Epics in your table as the top of the hierarchy and the ISSUE_KEY from Tasks as the second level. ISINSCOPE('Tasks'[ISSUE_KEY) should return true for task lines and false for Epics lines.
Greg_Deckler thanks for the reply, way beyond my level of understanding at the moment, as I have only been using powerBI since middle of January.
Would your tool MHGDQM help me here or would it be like throwing myself into a tank of piranha?
- Greg_Deckler
Anonymous Might help although I do not think I have included MM3TR&R yet which is kind of what you are looking for. Try something like below. Basically at the "group" level (first hierarchy level) you are going to have multiple Tasks. So, if you have only a single Task, then you are at the second level of the hierarchy, otherwise, you are at the top level of the hierarchy. This uses HASONEVALUE instead of ISINSCOPE but same concept.
Measure = IF( HASONEVALUE('Tasks'[ISSUE_KEY]), MAX('Tasks'[SUMMARY]), MAX('Epics'[SUMMARY]) )