Forum Discussion

Murali777's avatar
Murali777
Icon for Helper III rankHelper III
4 years ago
Solved

Consolidate Measures into one Table

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. 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

4 Replies

  • Samarth_18's avatar
    Samarth_18
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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's avatar
      Murali777
      Icon for Helper III rankHelper III
      4 years ago

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.