Forum Discussion

SillySuzy's avatar
SillySuzy
Regular Visitor
2 years ago

How To Exclude Summary of Value For Certain Columns

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 🙂 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.