Card total

[TechFluffyRider]

HI 

I created a report from an Excel sheet that I update each week. Today I did the changes to the spreadsheet but when I updated by report on Power Bi everything worked except my card which feeds off my total Cost column on my spreadsheet. The total there doubled for some wierd reason.

But as you can see from my data the actual total is exactly half of that shown on the report.

Anyone have any idea why this is doing it?

Matt

[Samarth_18]

Hi @TechFluffyRider ,

Have you tried to remove the column and add it again sometime visual cached the data? Also check by dragging  same column on the card in the fresh page then apply the required filter one by one and check if you are getting correct output or not.

Thanks,

Samarth

[TechFluffyRider]

Any suggestions ?

[Migasuke]

Hi,

I think this total you see in your data view is actually duplicated row. So you have lot of rows, which sums up to 234K but at the same time it seems you have another subtotal in your source with 234K.

Check your source, especially the last row.

[TechFluffyRider]

Hi 

I double checked my source to begin with and getting the correct total. If I click on any other part of my report the card is showing the correct total this is only happening when I am looking at the total income.
Matt

[VIJAYKUMART · Accepted solution]

I think u have Total Calculated Column in ur excel i.e.,  234,720, you need to delete that total row and refresh once data set or create a new measure after changing the above mentioned in data source.  I hope you will be more clear on by extracts.

Problem: 

Data Source: 

Card Visual

Solution:

data source modified:

Card Visual: