Forum Discussion
Adding a calculated Row to a Matrix
Hello,
To my matrix, I am trying to add a calculated row (in red). I am able to get the measure to display as a row, but it shows up after every row and I'd like to only view it at the end and not after every row. I looked at the properties, but cant seem to hide them. Please advise on how to achieve that specific view.
What I'd like to see.
| segment | 2018 | 2019 | 2020 |
| Region | 600 | 300 | 100 |
| West | 400 | 80 | 20 |
| North | 50 | 100 | 20 |
| East | 100 | 30 | 20 |
| East Use Rate | 17% | 10% | 20% |
But what i get in PowerBI is as below.
| segment | 2018 | 2019 | 2020 |
| Region | 600 | 300 | 100 |
| East Use Rate | 17% | 10% | 20% |
| West | 400 | 80 | 20 |
| East Use Rate | 17% | 10% | 20% |
| North | 50 | 100 | 20 |
| East Use Rate | 17% | 10% | 20% |
| East | 100 | 30 | 20 |
| East Use Rate | 17% | 10% | 20% |
Thank you.
Hi PBI5851 ,
Try to do like this.
1. Use "Unpivot Columns" feature to get such a table.
2. Create a measure like this.
Measure = IF( HASONEFILTER(Sheet3[Value]), MAX(Sheet3[Value]), AVERAGE(Sheet3[Value]) // Replace it with your "East Use Rate" code )Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
PBI5851 may be something like this
East Use Rate % = IF ( HASONEVALUE ( Table[Segment] ), BLANK(), <your east use rate % measure formula > )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
parry2k Your solution works on the value calculation in the sense that the %'s show only in the final row. However, the Rows with East Use rate% are displayed for every row with no value though.
segment 2018 2019 2020 Region 600 300 100 East Use Rate West 400 80 20 East Use Rate North 50 100 20 East Use Rate East 100 30 20 East Use Rate East Use Rate Summary 17% 10% 20% Hi PBI5851 ,
Try to do like this.
1. Use "Unpivot Columns" feature to get such a table.
2. Create a measure like this.
Measure = IF( HASONEFILTER(Sheet3[Value]), MAX(Sheet3[Value]), AVERAGE(Sheet3[Value]) // Replace it with your "East Use Rate" code )Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
