Forum Discussion
Avoid sum multiple times same value on column
Thank you so much for the quickly answers, they made me think and prepare and simple example that helps to find the solution:
When I am talking about a view, I mean a database view (data from multiple tables together) and that's here where I made a mistake
My model was like that:
That's the data
So, when I go level down in the grid the behaviour was like this:
As you can see, power bi is multipling the batch amount by the number of registers so the total amout is wrong.
But, as I said before, to show you a simple model I create this one:
It works well cause Power BI knows the amout of batch is not a part of the registers.
Now I have to find how to make it work without both direction relation between Revision and Batch. I read that is not recommended
Sorry for make you waste your time and thank you so much.
Regards,