How to do it...

Clearly, we need to fix the total line for our measure. To demonstrate how this is done, perform the following steps:

1. Create the following measure:

SumTotal = 
    IF(
        HASONEVALUE('R05_Table'[Item]),
        [Sum],
        VAR __Table = SUMMARIZE('R05_Table','R05_Table'[Item],"__value",[Sum])
            RETURN
                SUMX(__Table,[__value])
    )

2. Place the SumTotal measure in the Table visualization created previously.

Note that the row values for the SumTotal measure agree with those for the Sum measure, but that the total row in the table displays 3,200 for SumTotal, which is what we would expect.