Forum Discussion
Subtotal error
Hello everyone,
After all this time I use BI, this is the first time seeing such weird thing...
Left side is my data, there are only 3 rows and it is integer type. Right side is report view, and as you see subtotal is 12599999. I tried viewing min and max value, they are all the same 4200000. Why is this happening? There is no calculation in report view, calculations are done in Power Query and it is 100% integer type.
Is there a way to fix this? XDDD
Thank you!
Best regards,
David
Hi primolee ,
I have not reproduced your problem, but I think you have two ways to solve this problem now.
1. Check the data model and recreate the table relationships.
2. Create a measure and add it to the table visual.Do you mind sharing your .pbix file?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
Hi primolee ,
Do you have the relationship established with Date Table.
I think the relationship is missing.
Regards,
Harsh Nathani
Hello Anonymous ,
Funny, there is no date column in this table. However, it has a relationship link to another table with Date column.
When I remove the relationship, subtotal is correct. However, this relationship is a must so I have to keep the relationship.
You can think of this table as a monthly budget table. I have another table containing daily spending. I am linking these two tables using Year/Month.
How should I solve this? Thank you.
Best regards,
David
Hi primolee ,
Which table is the Year/Month Colum which you have shown in the screenshot above.
Can you share your .pbix file.
Regards,
Harsh Nathani
primolee , what is the data type. If it decimal change t whole number and check
It is integer (whole number), and there is no decimal at all. Original data came from Excel and it is 4200000 in each row.
