How To Exclude Summary of Value For Certain Columns

[SillySuzy]

Hi,

I'm looking for help on how to exclude the aggregation of a second value for certain columns in a Matrix I have a image below of what I mean. I want to remove the highlighted value, but keep the "Total" value. I am comparing actuals to forecast, and I don't need the forecast to be compared to each column. Thanks 🙂 

[Anonymous]

Hi @SillySuzy ,

I can give you a workaround:
Try to use DAX instead of the Total of matrix. Close the Column subtotals:

And use DAX to calculated the Total, for example:

Total_SUM_Amount = 
CALCULATE(
    SUM('Table'[Value]),
    ALLEXCEPT('Table', 'Table'[Category]),
    'Table'[Type] = "Amount"
)

Total_SUM_F3 = 
CALCULATE(
    SUM('Table'[Value]),
    ALLEXCEPT('Table', 'Table'[Category]),
    'Table'[Type] = "F3"
)

Then just put these two measures into the Values of the matrix:

And you can only need to put Amount into this matrix without F3.
If you have any other questions about the workaround I provided, it would be helpful if you could provide a little sample data.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MattAllington]

There is no simple way like Excel Pivot tables. 
either build an Asymmetrical table yourself as I cover here https://exceleratorbi.com.au/building-a-matrix-with-asymmetrical-columns-and-rows-in-power-bi/

or use a third party visual such as InfoRiver