Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anand24's avatar
    Anand24
    5 years ago

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

Anand24's avatar
Anand24
Icon for Super User rankSuper User
5 years ago

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