Forum Discussion
Total Sales DAX Not Correct
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.
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.
4 Replies
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.
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.
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.
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
