Measures don't work with "show items with no data" option selected

[RandomText]

Hi,

having a bit of trouble trying to sum sales and balance.

Relationships:

When I add only item code and all the measures it's fine and works like it should.

But when I add at least 1 field from table "Pakuotes" everything goes to hell. At first table is empty because those codes doesn't have any rows in that table.

I can fix this with option "show items with no data", but then measures don't work and they are blank. Tho Total is displayed correctly.

If code will have entry in that table it will show correct measure value. How to fix this?

I tried to change relationship with that table to "Single" that it would not filter out anything, but then all those 6 items are displayed with all possible distinct values from that table. 😞 The same result as placing that field into the table with removed relationship.

[amitchandak]

@RandomText , Can you convert these 1-M bidirectional relationships as single directional and check

[RandomText]

Changed them. Resilt is the same. All codes show all possible values from that table. Like in last picture of first post.