Total sales is not equal to All sales while calculating percentage

[Alex_Hasan]

Hello, this is the problem I am having right now.

I am practicing AdventureworksDW 2019.

From accounting point of view, the Total sales would be  = sales amount+ tax+ freight [ you know that all costs related to sales must be added up]. so the amount we get is $17,727,276.

Now, when I calculate All Sales =  CALCULATE([Total Sales], All(Sales)) - Sales is the table name here, the number should be $17,727,276.  But here it's not the case. what should I do to solve this? 

[Alex_Hasan]

Thank you so much, it worked 🙂.

[Whitewater100]

You are welcome. 

[Whitewater100 · Accepted solution]

Hi:

If your data has sales for more than one year, using "ALL" will take filters away and give you grand total for everything. Since you are filtering on Name, is it possible that some transactions do not have a name associated with them?

You can test by putting these two measures in a separate card and comparing. [Total Sales] should equal ALL sales if no filters are applied to [Total Sales].

I hope this helps!