cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Dax: add a member in a dimension

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Dax: add a member in a dimension

Hi @Lidou 

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:

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Dax: add a member in a dimension

Hi @Lidou 

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:

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Helper I
Helper I

Re: Dax: add a member in a dimension

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

 

 

 

Highlighted
Frequent Visitor

Re: Dax: add a member in a dimension

Hi, 

 

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

 

Kind regards,

 

Gilles

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors