Forum Discussion
Couldn't get the simple sum function for a column
Hi,
I have this sales table with the sales amount as one of the columns. And I have the date as a column. The sales table has the relationship connected to a calendar table. I need to total the sales amount. I have no problem getting accurate monthly sales amounts when generating a report with a month column. However, since I am needing to combine different sums from different tables, I was advised to create a new measure.
So I just used "create new measure" to sum the sales amount column. But when I ran a table using the new measure, the result shows some incorrect sales amount for some months and most months have no sales amount at all. The data does not match the monthly amounts I get when running a report without this new measure. Can anybody tell me what went wrong here? I am new to BI. If I missed some obvious info please ask.
I also attached a photo for the result. 2016 should have much higher sales than 2015 so the data is completely wacky. Please advise. Thank you!
10 Replies
Do you have any filters(page level/visual filters) in your report, Any slicers that are active as well. If so, can you please cancel those filters to get the accurate results.
Thanks! I've cleared the slicer. It got self fixed today when I reopened it. Power BI had a glitch or something. But I do have an issue which make me wonder if it has something to do with the glitch. That is, after I imported the sales data in queries, apply and close. The content data of the table doesn't show up in the data section. It's all grey there (see the photo below). I can go back to the queries to see the data, and I'm able to use the sales data when I create visual reports. I don't know why it happened this way. Is it because the file size? The data section just won't store and show up the content. Appreciate if your experience can explain this for me!
Looks weird.
Have you tried to close the file or Power BI and reopen or tried to restart you client?
Could you please describe more details on how you created the measure (dax formula would help) and a sample of eg. one month which showed to correct totals (which?) when you did not use the measure and now showing the wrong total (which?).
A screenshot of the relations whould help maybe either.
