Forum Discussion
Subtotal error
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.
Year/Month in the image is from monthly budget table. And I have another table just for Year/Month.
Monthly Budget
| <- 1 to 1, Bi-directional
Year/Month
| <- 1 to N, Bi-directional
Daily Spending
In the image above, I am pulling both Year/Month and Est. Imp. Per Month from the same table "monthly budget" and there is no other column from other tables.
Just now, I changed the second relationship to single-direction, and the subtotal is correct... I don't understand... Even if I don't use any columns from Daily Spending table or Year/Month table, subtotal is wrong... Shouldn't subtotal simply be adding all rows together?
And here is another problem:
I used Buget from Cue Table as my Max value and spending from daily spending as value, max value shown is still 12599999.
This is simply driving me nuts... XD
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 Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello v-lionel-msft
Because there are many sensitive data, I tried to recreate the same scenario with very simplified data. However, everything is perfect and I cannot recreate the error that I encountered previously. Maybe because there are more relationships involved in my original case.
Let me try to play around with the data.
Thank you so much for your help!