Create a calculated member in a tabular model

Question

Create a calculated member in a tabular model

Lidou123

Hall of Fame

Points: 3186
More actions
April 17, 2019 at 2:08 pm

#3426278
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 ?

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

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

Martin Schoombee SSCoach Points: 19128 More actions · Answer 1

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: 3186 More actions · Answer 2

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: 19128 More actions · Answer 3

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.