Consolidate Measures into one Table

Hi  Murali777 ,

You might consider using the SUMMARIZE function to create a new table containing the measures, but this new table cannot change dynamically with user selections on the report.

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).

Create calculated table.

Table 2 = SUMMARIZE('Table',"Measure",[Measure],"Measure 2",[Measure 2])

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.