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]) )
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?
Community ChampionAnonymous 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])
)
Greg_Deckler Thanks Greg, you are a superstar.