False SUM for result of DIVIDE

[joshua1990]

Hello everbody.

I have two tables. The first one shows me the planed value per item. The second one shows me the size per item.

Now I want to divide the plan per size.

Unfortunately, I get a false sum for a higher granularity (as you can see):

Area	Article	Plan	Batchsize	Plan / Batchsize
S22		194390	83441	2,329670066
	A1	27770	13885	2
	A2	13885	13885	1
	A3	97195	13885	7
	A4		14016
	A5		13885
	A6	55540	13885	4

There should be 14.

How can be that avoided?

[JarroVGIT]

I am not sure how you get this table as you show in your post (is it a new calculated table or are you merging the two tables using M?) 

What is important to note that when this is a representation of a Table visual (or a Matrix visual), that measures are evaluated also on the total row (in this case, your first row, indicating the whole of Area S22). 

I think I can help you better if you share your use case in a bit more detail, including some screenshots of your datamodel and what you are trying to achieve. 🙂

Let me know!

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[edhans]

The problem seems to be your model. You have a blank row, which tells me there are values in one table for the Article field and not the other. So your measure is not filtering by Article for that blank, but just for S22, and summing all values.

I'd need to see your two tables, the data, and the relationship column being used to help more, but maybe I've given enough info for you to move forwards for now.