Skip to main content

Power BI

New

Matrix Subtotals - Control calculation by column

Vote (6) Share
Pat Rogers's profile image

Pat Rogers on 15 Sep 2017 02:33:23

I have data that has Profit % as a column. My rows are projects and their tasks. For most of the columns a sum subtotal is fine, but summing the Profit % returns a ridiculous number. I need to enter a custom calculation based on the subtotals of the other columns.

OR I need to turn off the subtotal for this column.