none
Organizing measures in a separate table in SSAS tabular cube RRS feed

  • Question

  • Hello

    I have lots of calculated measures scattered across two tables and want to organize them. How can I create a "dummy" calculated table so that all measures can be transferred to the new table.

    Regards

    Priyadarshi


    Tuesday, August 13, 2019 1:21 PM

Answers

  • On recent version of SSAS you can use the table constructor syntax to produce a dummy column with a single value (you would then hide this column)

    eg.

    Measures Table = {1}

    On older versions of the engine you could use the ROW() function to do the same thing

    eg.

    Measures Table = ROW("Column1" , 1)


    http://darren.gosbell.com - please mark correct answers

    Wednesday, August 14, 2019 9:05 PM
    Moderator

All replies

  • Hi Priyadarshi,

    Thanks for your post.

    Per your description, how to create a calculated table depends on which dimension columns you would specify. For your scenario, we usually use function SUMMARIZE,SUMMARIZECOLUMNS to combine measures.

    Reference

    SUMMARIZE

    SUMMARIZECOLUMNS

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, August 14, 2019 6:09 AM
  • On recent version of SSAS you can use the table constructor syntax to produce a dummy column with a single value (you would then hide this column)

    eg.

    Measures Table = {1}

    On older versions of the engine you could use the ROW() function to do the same thing

    eg.

    Measures Table = ROW("Column1" , 1)


    http://darren.gosbell.com - please mark correct answers

    Wednesday, August 14, 2019 9:05 PM
    Moderator