Forum Discussion

shr_sday's avatar
shr_sday
Regular Visitor
6 years ago
Solved

Matrix Visual Hierarchy Issues

Somewhat new to Power BI and DAX and everything, so please forgive my ignorance. I am trying to build a Matrix table to view JIRA tickets. I want to group tickets by the Epic to which they are associ...
Need Help
  • v-joesh-msft's avatar
    v-joesh-msft
    6 years ago

    Hi shr_sday ,

    I think you may need to create the following 5 measures:

    Measure IssueType = IF(ISINSCOPE('Table'[Key]),CALCULATE(MAX('Table'[IssueType])),CALCULATE(MAX('Table'[IssueType]),'Table'[IssueType]="Epic"))
Measure Summary = IF(ISINSCOPE('Table'[Key]),CALCULATE(MAX('Table'[Summary])),CALCULATE(MAX('Table'[Summary]),'Table'[IssueType]="Epic"))
Measure Description = IF(ISINSCOPE('Table'[Key]),CALCULATE(MAX('Table'[Description])),CALCULATE(MAX('Table'[Description]),'Table'[IssueType]="Epic"))
Measure Status = IF(ISINSCOPE('Table'[Key]),CALCULATE(MAX('Table'[Status])),CALCULATE(MAX('Table'[Status]),'Table'[IssueType]="Epic"))
Measure EpicLink = IF(ISINSCOPE('Table'[Key]),CALCULATE(MAX('Table'[EpicLink])),CALCULATE(MAX('Table'[EpicLink]),'Table'[IssueType]="Epic"))

    Results are as follows:

    Here is a demo, please try it：

    https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EertCMfbUNFMqcqfIKLfc7UBZtHtT5DtHPJk2CBatT3K7Q?e=PTMNVX

    Best Regards,

    Community Support Team _ Joey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-joesh-msft's avatar
v-joesh-msft
Solution Sage
6 years ago

Hi shr_sday ,

I am not sure if I fully understand what you mean, you can try the following measure:

Measure Percent of OE = IF(ISINSCOPE('GetIssues'[Key]),CALCULATE([Percent of OE]),CALCULATE([Percent of OE],'GetIssues'[IssueType]="Epic"))

Results are as follows:

 

Here is a demo, please try it：

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EchKBNJGxHRCtduyuJKxoTYBw2SrvPQvtJS-_CvAnoulPQ?e=yypbgx

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

shr_sday's avatar
shr_sday
Regular Visitor
6 years ago

Sorry for the tardy response. Been on vacation.  :-)

 

I ultimately got it to work by changing the way I was calculating the Original Estimate and Time Spent columns. Once i got this calculating for the whole group properly, the percentage just worked as expected. Thank you once again for your efforts and the fantastic examples!