Forum Discussion

AO1's avatar
AO1
Frequent Visitor
2 years ago
Solved

Create data table using slicer selection

Hi,   I will really appreciate help with this problem. I want to create a new data table, Table 2, based on slicer selection of an existing table, Table 1.   Table 1 contains a variable called "T...
  • Fowmy's avatar
    Fowmy
    2 years ago

     When you create a calculated table in a table, any selection that you make on your report canvas is not known to the formula in the calculated table because what's happens is the order in which the stages take place. First the model is completed then the tables are ready for report building. Try to build a measure instead which can make use of the slicer selection. I hope this is clear. 

     

    AO1

Fowmy's avatar
Fowmy
Super User
2 years ago

 When you create a calculated table in a table, any selection that you make on your report canvas is not known to the formula in the calculated table because what's happens is the order in which the stages take place. First the model is completed then the tables are ready for report building. Try to build a measure instead which can make use of the slicer selection. I hope this is clear. 

 

AO1