Display of data not right

[holyspirit2207]

I don't understand why the total was 8356 for all the quantity of items have been sold but when i display the total quantity of items sold by location the numbers just dont fetch up with the sum of quantity items have been sold 

[v-priyankata]

Hi @holyspirit2207 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-priyankata]

Hi @holyspirit2207 
I wanted to check if you had the opportunity to review the information provided by @MFelix . Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-priyankata]

Hi @holyspirit2207 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[MFelix]

Hi @holyspirit2207 ,

First of all the information you give altough is complete is not usable since it's just a set of images and it's not possible to understand what is happening.

Please see this post regarding How to Get Your Question Answered Quickly (courtesy of @Greg_Deckler) and How to provide sample data in the Power BI Forum (courtesy of @ImkeF).

However one thing that I can see is that you have a many to many relationship with bi directional filters turn on this usually returns inconsiste results.

Can you please share some more insights.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[holyspirit2207]

I just sent you the the pbix file on the direct message, can you take a quick look through it ?

[MFelix]

37m ago

Hi @holyspirit2207 ,

Your problem is with the many to many relationships, in this case the best option is to create a unique column compose by Shelf and Item on both tables I added the following:

Customer table
Shelf_Item = df_customer[Shelf ID]&"_" & df_customer[Item ID]

Item table
Shelf_Item = df_item[Shelf ID] & "_" & df_item[Item ID]

I also change the relationship from shelf to costumer passing it trough item this will give you the following setup:

Now you can use the information from shelf and from item to get the final result from customer. 

Has you can see the result is now correct.

Be aware that I also took the ShelfID from the Shelf table instead of the item one.

Many to many relationships with bidirectionality should not be created.