Total Sales DAX Not Correct

[khaen]

I have a sample data report with just a single table of data and a slicer for Date and slicer for Custumer Name.  I am trying to show Total Sales (for all customers) for the time interval selected by the slicer.  When I change the Date slicer it changes the Total Sales number, like it should.  But when I pick a customer it also changes the Total Sales, which it should not.  I am using:

Total Sales = CALCULATE(sum(Data[Sales]),ALLEXCEPT(Data,Data[Invoice Date]))

I thought this should ignore all filters except the date?  I have a small sample file, since it seems to be data dependant.

https://curtjoa-my.sharepoint.com/:u:/g/personal/khaen_joa_com/ESsJpMiKBWdMg0Lp9jndEscB4v4ICbtFXr3W2...

[Greg_Deckler · Accepted solution]

I'm wondering if you had your customers in a dimension table and based your slicer on that if your measure would work. Just ran into a similar situation with ALL in another thread.

https://community.powerbi.com/t5/Desktop/Suspected-BUG-when-using-ALL-with-multiple-non-ignored-slic...

[khaen]

It also is a pain for all charts.  I have one chart that show sales of each part number.  I click on a part number in there and the Total Sales is broke again, unless I create a table of part numbers and show that on the chart instead.  But it seems to work.

[v-juanli-msft]

Hi @khaen

Does the solution solve your problem indeed?

If so, could you kindly mark the answer as a solution so others may refer to it.

Best Regards

maggie

[khaen]

It does work!  Seems like a strange fix, but I guess it is not the end of the world.  I also need to point all my charts to this new table, otherwise they still break the total.  But all seems to work.