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]) )
Super UserAnonymous , seem like you have used them in values. You should use them in row.
or create a measure using isinscope and only display at the correct level
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Trouble is, if i use them in row it becomes like this
which isn't what I want, i also have the same problem with status, it also propogates upwards.
- Greg_Deckler
Community Champion
Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.