Table values don't add up

[mikesqu]

Hi all,

As you can see below I have a table of sales giving me the correct column total of 136, but the individual values only add up to 134. The table isn't restricted by size, but I am at a loss as to why the figures don't add up. The filters should be universal.

Any help will be amazin.

Cheers

Mike

[mikesqu · Accepted solution]

Definite an issue with the source table. I will have to review the set up. Thanks for your help anyway guys

[Anonymous]

@mikesqu 

Should not be a bug, but this makes the model difficult to understand, maybe just share a sample pbix file.

Regards
Paul

[PhilipTreacy]

Hi @mikesqu 

Silly question, but are the values for Total Sales actually integers? If they are decimal and in the Data window you've  got the number of decimal places for that column set to 0, the values are being rounded too, hence the discrepancy?

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[mikesqu]

No these are integers so no rounding issue

[amitchandak]

@mikesqu , need to check calculation and data for that. Assume total sales is you measure try a new measure like and check

total sales new =sumx(Values(Table[source]),[total Sales])

also refer :https://www.youtube.com/watch?v=ufHOOLdi_jk

[mikesqu]

Interesting video, but it is the total figure which is correct and the values which require changing.

The results are from 2 tables:

• Lead table 
• Sale table

Both of these have a relationship with the following tables:

• Source table by source name
• Date table by lead creation date / sale date

As you can see below the 8 in the 3rd row needs to be the correct 10. The top table is using the source table, the second table is using the sources from the sales table. Unfortunately I need the source table used so that the correct number of leads are represented.