Create a calculated member in a tabular model

  • Lidou123

    Hall of Fame

    Points: 3042

    Hello All,

    I am trying to add a calculated member in a dimension.

    In Multidimensional model, I do that like this:

    CREATE MEMBER [Material].[Department].[AB] ASAGGREGATE({[Material].[Department].&[A], [Material].[Department].&})

     

    Is there a way to do the same in tabular model ?

  • Martin Schoombee

    SSCoach

    Points: 18997

    Yes, add a calculated column to our table/entity: https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/ssas-calculated-columns?view=sql-server-2017

     

  • Lidou123

    Hall of Fame

    Points: 3042

    Hello

    Thank you for your answer.

    But I want to create a new member in the same column (a calculated member) not a calculated column.

    For instance, I want to have in my Customer dimension a new member like 'Top 10 clients'.

    It's easy to do this in a multidimensional Model with MDX.

    But I don't know what to do the same in Tabular Model

     

  • Martin Schoombee

    SSCoach

    Points: 18997

    So it's really a set you want to create? If you need something to be dynamic, you'd probably have to create a calculated table and use DAX to populate it with the top 10 clients.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply