Forum Discussion

erihsehc's avatar
erihsehc
Helper III
8 years ago
Solved

allselected function not working

  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 sheet...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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