Forum Discussion
Adding a calculated Row to a Matrix
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.
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 Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-lionel-msft where do I place this measure in report. Its urgent. Please reply fast. Thankyou
Hi v-lionel-msft where do I place this measure in report. Its urgent. Please reply fast. Thankyou
