- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# Is it possible Power BI is calculating incorrectly?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

01-13-2016 11:30 AM

So I've been fiddling with some figures and doing a bit of validation, when I came across a discrepency that I haven't been able to identify the root cause of it.

Is it possible Power BI is somehow incorrectly calculating my data? (Unlikely, I know).

464,655.79 minus 2,912,595.64 = (2,447,939.85)

I have been unable to explain why my PowerBI Table visual is giving me 10 less than the correct arthimentic.

Thanks in advance

Solved! Go to Solution.

Accepted Solutions

## Re: Is it possible Power BI is calculating incorrectly?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

01-13-2016 11:44 AM

There's no mistake if you substract the 2 numbers in the Visual Total.

## Re: Is it possible Power BI is calculating incorrectly?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

01-13-2016 11:50 AM

I'm fairly certain that's the correct number. What are you double checking on?

## Re: Is it possible Power BI is calculating incorrectly?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

01-13-2016 11:56 AM

## Re: Is it possible Power BI is calculating incorrectly?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

01-13-2016 11:59 AM

$464,6**6**5.79 in the Visual

$464,6**5**5.79 in your calculation

Here's your missing 10

All Replies

## Re: Is it possible Power BI is calculating incorrectly?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

01-13-2016 11:44 AM

There's no mistake if you substract the 2 numbers in the Visual Total.

## Re: Is it possible Power BI is calculating incorrectly?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

01-13-2016 11:50 AM

I'm fairly certain that's the correct number. What are you double checking on?

## Re: Is it possible Power BI is calculating incorrectly?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

01-13-2016 11:56 AM

## Re: Is it possible Power BI is calculating incorrectly?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

01-13-2016 11:59 AM

$464,6**6**5.79 in the Visual

$464,6**5**5.79 in your calculation

Here's your missing 10

## Re: Is it possible Power BI is calculating incorrectly?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

01-13-2016 12:28 PM

Oh gosh! Thanks gentlemen. Thoroughly embarrased