Forum Discussion
dynamic dimension
Hi, Below are some of the steps I've taken and got stock in step 3 Step 1 - I created a Metric Selection table as per below Step 2 – I created the measure: Metric Selected = SELECTEDV...
Hi Emmy66
Your error is caused by there will be duplicate values in uid after you click apply changes which has a one to many relationship currently.
You may delete the relationship(one to many), then apply changes in power query and build a many to many relationship between uid in User and other tables.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous, thanks for your continued support. The User table is joined to many other tables, so, I'm not sure how to proceed with the many-to-many and the impact it will have