Products price per category sum doesn't work

[nikboe09]

Hi all,

I've got a problem here that I do not understand.

Someone has a product with productCode and might have bought addon insurance from category 1, 2, 3 or 4.

The 4 categories have different prices, e.g. 1 = $10, 2 = $20 etc. Not everyone has bought the optional insurance.

The tables are:

Products: ID | productCode | productName | ...

Categories: productCode | Category | Price

productCodes are not unique. 

Now the problem:

If I create a visual with products.ID and categories.price, it shows the price, but doesn't create a sum.

If I select sum for the value, every product has the same sum, and the total sum is also the same.

What can I do? Any ideas?

Thanks!

[Anonymous]

Hi @nikboe09 

I have no way to restore your scene, so I don't know the structure and relationship of the data you mentioned very well. Can you provide a simple pbix file and the expected effect ? This will better help us solve the problem.

Best Regards

Community Support Team _ Ailsa Tao

[Anonymous]

Hi @nikboe09 

Did you choose the Sum for the field ‘Price’ ?

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nikboe09]

Yes, I did. As stated above in my question.

[amitchandak]

@nikboe09 , You should use in visual product id, Categories category, Categories price.

can you share the expected output?

[nikboe09]

It seems like the sum doesn't work, if the productCode is the same. They all bought the same product.

[nikboe09]

It seems like the problem was that the relationship property wasn't set to "both directions". 

But the sum per company still doesn't work: