Power BI total doesn’t add up? Try these solutions

3 min. read

Updated onOctober 4, 2023

updated onOctober 4, 2023

Share this article

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Power Bi is a powerful data visualization BI tool from Microsoft. It offers companies the ability to present data in new ways with interactive data visualization. That said, sometime, in Power Bi total measures may not add up. Multiple users have reported “Power BI total doesn’t add up” issue.

Several users have reported similar issues in thePower BI community. According to the users, the totals don’t add up the table after applying filters.

Hi,I have this measure -> GP = – 1800 + SUM(vw_PivotVisitsInvoiced[Income Generated])Calc Column -> Income Generated = vw_PivotVisitsInvoiced[Visits_NoHrs] * 6.25Why is my total below not right?

This error is usually caused due to the incorrect table relationship or calculation formula. If you are also troubled by this issue, here are a couple of troubleshooting tips to fix Power BI total doesn’t add up error.

How to fix Power BI table doesn’t show total

1. Check table measures

How to bypass Power BI sign-in issues quickly

2. Check your table relationship

3. Other solutions to try

The solution for Power BI total doesn’t add up can vary for each user. However, most of the time, the issue is due to incorrect measures. Follow the steps in this article and try to make changes to your measures accordingly.

If the issue persists, use the Power BI community link given above to get more help. The Power BI community can help you with your problem.

Power BI total doesn’t add up? Try these solutions#

How to fix Power BI table doesn’t show total#

1. Check table measures#

2. Check your table relationship#

3. Other solutions to try#

Power BI total doesn’t add up? Try these solutions

How to fix Power BI table doesn’t show total

1. Check table measures

2. Check your table relationship

3. Other solutions to try