MDX Calculated member in Dax

[Anonymous]

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] AS
        AGGREGATE({[Material].[Department].&[A], [Material].[Department].&[B]})

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

Thank you for your help.

[v-juanli-msft]

Hi @Anonymous 

Could you show an example of original table and output after performing the formula?

Best Regards
Maggie

[Anonymous]

Hello @v-juanli-msft 

I hope you are doing well

For sure,

I have for example a table like this: 

And I want to have in my reporting a table like this:

I need to create these calculated members ('>=20 y',  'Adults (From 20 to 40 y)' , 'Kids (From 0 To 10 y) '  to the bottom of table that summarize and categorize the ages.

Thank you for your help.