Consolidate Measures into one Table

[Murali777]

Hi All,

I'm having measures table and i want to consolidate all the measures into column in a table like below screenshot.

Kindly any one help me in this situation. 

[Anonymous · Accepted solution]

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.

[Murali777]

Thank you Liu Yang.

[Samarth_18]

HI @Murali777 ,

To achieve this follow below steps:-

1. Create a table with single column from enter data like below:-

2. Now Move your measures  to newly created table from home table or from model view or directly create a new measure inside the new measure table.

3. Now hide or delete the column from new table and then save it:- 

Thanks,

Samarth

[Murali777]

Hi Samarath,

Thanks for your time. But the question is, i'm already having the group of measures and i need to form a table with the existing Measures.

e.g) Col1=Measure1, Col2 = Measure 2, Col3= Measure 3.

Like wise i need to form a table by using the existing measure value.