My pie charts displaying an unexpected total

[iGWizard]

I need this pie chart to equal the card up top. They're both using exactly the same measure although pie chart is split by item. Filters are set exactly the same on both. I'm bewildered as to why when split into pie chart, I'm seeing different figures.

Pie chart 

Here is a breakdown of the pie chart in a matrix.

As you can see, the rows are displaying the same as the slices in the pie chart. And they add up to more than the total. The total is the same as what I'm seeing in the above card. 

If anyone has a solution to this, it would be amazing. I need the pie chart slices to equal the card.

Thanks!! 😄

[Anonymous]

Hi, @iGWizard 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

If it is not resolved, I hope you will provide the full .pbix file via OneDrive or SharePoint. Please be careful to remove all sensitive information and we will do our best to provide ideas for your issue.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[miTutorials · Accepted solution]

I hope you realised that your measure is returning incorrect total in your card as well as the table.

Check the below video to fix incorrect totals.

Why Incorrect Totals in Power BI ? How to Fix Incorrect totals | MiTutorials | #PowerBI - YouTube

[iGWizard]

Of course. This is the whole point of the question lol. Thanks for sharing the useful link

[PBIViz_2024]

Hi,

To answer this quetion it is better to have the dataset with the issue.not the real data but with dummy data.Without seen the data it is hard to tell what the problem is.However It might be an issue in your relationships.If you are connecting fact table and dimension table to get the items check the relationship.

Regards