Changing the total calculation in table

Hi RichOB 

The reason your Family Payment column is showing an incorrect total (such as £260.94 instead of £7045.38) is because of how Power BI handles totals for measures. Unlike calculated columns, measures are evaluated in the current filter context of each row or cell — and at the total level, that context is removed, so your condition 'Table1'[Description] = "Family Payment" no longer filters correctly. As a result, Power BI calculates the sum using the total context rather than summing up the visible “Family Payment” row values. To fix this and make the total display correctly, you can modify your DAX measure to calculate the total explicitly across all rows that meet your condition, regardless of visual context. Try this revised version:

Family_Payment =
SUMX(
    FILTER('Table1', 'Table1'[Description] = "Family Payment"),
    'Table1'[Amount]
)

This formula uses SUMX with a FILTER function to iterate through all rows of 'Table1' where the description equals “Family Payment,” and sums their amounts directly. By doing this, both the individual rows and the total in your visual will show the correct value (£7045.38), since the logic now applies consistently at every level of aggregation.