Table visualisation not slicing correctly

[Barrettone]

I have created 3 custom columns based on simple density calculations (input/gsm), (output/gsm), input-output, in a data table on a Power BI Desktop report. 

However, when I create a table visualisation it does not seem to slice correctly - I would expect it to summarise the figures into one line, however this is not happening. Nor is it giving a Total. 

Note that these columns are in a table where the date is linked correctly. and other figures slice as expected and give a total as expected. 

Image below- the lower chart is the problem, the expected result is as per the upper chart (not the same measures).

The problem chart has a line per data input, and is not being summarised or totalled.

[Barrettone]

Hi @SpartaBI , can't do that unfortunately - the figures are confidential. 

[SpartaBI]

@Barrettone I suggest you create a replica with fake data and small amount of rows so you could share it and then look at the solution me or someone else here will give you on the sample file

[SpartaBI]

@Barrettone you can PM me and we can look together in zoom if you want