Forum Discussion
Solved
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...
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.
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.