Problem: When summarizing (Sum) for a column, some items are added as one

[yatinpurohit]

I have a table visualization for a SharePoint list containing expenses. The table (expenses) displays the following columns - Date, Details, Type, Amount. I require to show the total (sum) of Amount field at the bottom. All this works. 

Problem: If there are 2 expenses with same Date, Details and Type the amounts is added up and it shows as one entry. We want to show 2 different entries even if the column data may be same. It is confusing when you see 2 entries in SharePOint list and just one in Power BI, even if factually information may be correct.

Please advise.

[SivaMani · Accepted solution]

@yatinpurohit,

You can select Don't Summarize for the column. It will solve your problem. However, you won't see total at bottom of the table.

If you want to see the total as well, assign a unique ID(maybe an Index value) for the values which are having the same Date. Details, and Type. 

Regards,

Siva

[yatinpurohit]

Thanks for your inputs, it works but I do need total.

I can add SharePoint list ID which is unique to the table. And indeed this fixes the problem. However, it has no relevance to end-user and therefore not a good visualization or use of screen space.