Forum Discussion

PBI5851's avatar
PBI5851
Helper V
6 years ago
Solved

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 ...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    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.

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

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.

Sania's avatar
Sania
Frequent Visitor
3 years ago

Hi v-lionel-msft where do I place this measure in report. Its urgent. Please reply fast. Thankyou