Create Calculated Columns from matrix's column

Hi TK_FPA ,

There is no more elegant way to implement your requirement, you can refer to this post below to see if the solution can be used as an alternative...

First, you can create three measures as below:

Measure1 =
IF (
    ISINSCOPE ( 'Table'[Financial Year] ) || ISINSCOPE ( 'Table'[Subsidiary] ),
    BLANK (),
    [Total Entity]
)

Measure2 =
IF (
    ISINSCOPE ( 'Table'[Financial Year] ) || ISINSCOPE ( 'Table'[Subsidiary] ),
    BLANK (),
    [Adj Entity]
)

Measure3 =
IF (
    ISINSCOPE ( 'Table'[Financial Year] ) || ISINSCOPE ( 'Table'[Subsidiary] ),
    SUM ( 'Table'[Actual] ),
    [Total all]
)

Then follow the steps in the link below:

Matrix visual - Measure to be shown only in total's part of visual

A workaround would be:

1. Select the Values fields(Measure1, Measure2 and Measure3)you want to hide.

2. In the visualization menu, go to Format--> Column headers and set both Auto-size column width and Word wrap to Off

3. In the visual, reduce the width of the column until it disappears completely. This way it will be still there, but completely hidden.

---

Best Regards