Forum Discussion
Table values don't add up
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
Definite an issue with the source table. I will have to review the set up. Thanks for your help anyway guys
6 Replies
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
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.
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.No these are integers so no rounding issue
mikesqu
Should not be a bug, but this makes the model difficult to understand, maybe just share a sample pbix file.Regards
PaulDefinite an issue with the source table. I will have to review the set up. Thanks for your help anyway guys
