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 ??
Go to Solution.
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:
View solution in original post
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 ?
Did you eventually found a solution for this? I have the exact same issue.
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.