Forum Discussion
Total not adding up the row values in a Matrix visual
I have a matrix visual where I need to show the Products and: 1. one column with the quantity of sold Products 2. one column with the the most recent (before the selected Year & Month) quantity pro...
Hi Anonymous ,
You ALL function is ignoring all the filter contexts and that's why total is not getting changed on slicer value changes.
Try replacing ALL with ALLSELECTED and the totals should probably change. ALLSELECTED will take the slicer filtering into consideration.
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
amitchandak
Super User
Super UserAnonymous , Try like
SUMX(Production[product]; IF(ISBLANK([Sold QTY]), BLANK(), myResult))
Also try allselected, in place of all