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 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.