Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report

According to this article, Calculated Column/Table Change Dynamically According to Slicer Selection in the Report, it is not possible to create a calculate column/table that can change dynamically wi...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous  - Calculated Columns are created and stored in the table when the model is refreshed. The value stored in the row won't change according to the user selection.

     

    What are you trying to accomplish?

Thejeswar's avatar
Thejeswar
Super User
7 years ago

Hi Anonymous,

Yes definitely you can create a parametrized Calculated Column based on SELECTEDVALUE DAX. But I am not sure if it is possible to create a parametrized calculated table using SELECTEDVALUE.

 

As per my understanding, we will not be able to create a parametrized Calculated table using SELECTEDVALUE DAX..

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thejeswar, Thanks for the response!


    Can you give an example of a dynamic calculated column? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Anonymous  - Calculated Columns are created and stored in the table when the model is refreshed. The value stored in the row won't change according to the user selection.

       

      What are you trying to accomplish?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Anonymous,

         

        Thanks for the response! I just want to know if it's possible. 

         

        Just to clarify, dynamic selection only works for Calculated Measures and NOT for Calculated Columns and Tables?