How to display the quantity for each item/customer insteas of total Sum

[EZV12]

Dear all,

I would like to display the quantity for each item/customer, but the report gives me the total sum of quantity. How to figure it out? 

Here is the link of a sample pbix file and a picture to show you more details:

https://1drv.ms/u/s!AnbNXrfr-X8jduITO752HHE1mOE?e=9IW0Ls 

Thanks and best regards

Rachel

[aj1973 · Accepted solution]

Hi @EZV12 

The easiest and fastest way(even though it is not recommended)  is to change the direction of this relationship to both

[EZV12]

Dear Amine,

There is a problem : the qty is linked to each item, but not each correspondant customer.  I need the quantity for each item & customer. May you please help me to find another solution?

Thanks

Rachel

[EZV12]

Dear Amine,

It works!! Thanks a lot!

Best regards

Rachel