Forum Discussion

lcd's avatar
lcd
Frequent Visitor
9 years ago
Solved

New table with measures values

Hi everyone,  my case is that: - I have a main table with measures based on other fact tables and a calendar table - now I want to build a table with DAX code (with SELECTCOLUMNS) to hold the meas...
  • v-ljerr-msft's avatar
    9 years ago

    Hi lcd,

     

    It is the expected behavior.

     

    Not like measures, calculate columns/tables(like your myMeasureTableare computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report(like a Slicer).

     

    So it is not possible to create a calculate table which can change dynamically with user selections on the report. :smileyhappy:

     

    Regards