Forum Discussion

holyspirit2207's avatar
holyspirit2207
New Member
1 year ago

Display of data not right

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 fetc...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
1 year ago

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's avatar
    holyspirit2207
    New Member
    1 year ago

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

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      1 year ago
      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.