Dax: add a member in a dimension

[Anonymous]

Hello

I am encountering a problem at work.

I would like to add members in a dimension.

Basically, I would like to add into my customer dimension, a calculated member who will get me the customer withe the maximum sales.

I do not wish to have a measure but rather a member in the dimension.

I know it's possible to do it in MDX, but it is possible in DAX ??

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

It is impossible to add a member to the original dimension in power bi.You may create a new table with UNION function to combine the new member with the original dimension.For example:

Regards,

Cherie

[Anonymous]

Hello 

Thank you for your help.

But how about the calculation ?

Because d = sum(a;b).

Is there a way to have it without creating a new calculated measure ?

Thanks

[Gilles_DR]

Hi, 

Did you eventually found a solution for this? I have the exact same issue. 

Kind regards,

Gilles