Solved: allselected function not working

erihsehc · ‎10-24-2017

hi, for the above tables, using the allselected function to get the sum of sales amount from sheet1. I would expect that when I select different division on the slicer from sheet1, the selected sales amount would change. However, it does not work. Would expert help on doing this task? thanks

Anonymous · ‎10-24-2017

Hi,

You are creating a calculated column and these are not re-calculated when you interact with slicers in your report.

To be able to do this kind of dynamic calculation you need to create a measure instead of the calculated column.

If all you are trying to do is to calculate the sum of sales for your table you don't need a complicated measure. Just add the customer from your Fact table to rows of your table and then add Sales to your values and it will give you the sum of sales with respect to filters and slicers coming from the same table.

Br,

Magnus

View solution in original post

Anonymous · ‎10-24-2017

Hi,

You are creating a calculated column and these are not re-calculated when you interact with slicers in your report.

To be able to do this kind of dynamic calculation you need to create a measure instead of the calculated column.

If all you are trying to do is to calculate the sum of sales for your table you don't need a complicated measure. Just add the customer from your Fact table to rows of your table and then add Sales to your values and it will give you the sum of sales with respect to filters and slicers coming from the same table.

Br,

Magnus