Forum Discussion
Total Sales DAX Not Correct
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.
Community ChampionI'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.
v-juanli-msftCommunity Support
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
