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...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi lcd,

     

    It is the expected behavior.

     

    Not like measures, calculate columns/tables(like your myMeasureTable) are 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

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi lcd,

 

It is the expected behavior.

 

Not like measures, calculate columns/tables(like your myMeasureTable) are 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

lcd's avatar
lcd
Frequent Visitor
9 years ago

Thanks v-ljerr-msft, I understand. I thought this kind of tables were like measures. I will look for other solution.

Regards