Forum Discussion

nbitabc's avatar
nbitabc
Helper I
4 years ago
Solved

Retrieve value into one Dimension table into another dim table

We are new to PowerBI so please excuse if this question is too basic.   Have been trying to fetch a related value in a Dimension from another dim table but it is not working as expected.   Exampl...
Need Help
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, nbitabc ;

    I'm really sorry that I reconstructed the model, but there are still some deviations and I can't understand your logic. If you can modify it in my file and share the result you want to output, maybe it will be better? Or share your files after removing sensitive information? Looking forward to your reply!

    Best Regards,
    Community Support Team_ Yalan Wu

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, nbitabc ;

I think it is more convenient to create measure, but it is difficult to create column, so another table needs to be created. If measure is used, please try:

Measure = IF(MAX('Office_Loc_Dim'[Office_Location])="Remote",MAX('Region_Dim'[Region]),MAX('Office_Loc_Dim'[Office_Location]))

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nbitabc's avatar
nbitabc
Helper I
4 years ago

Thank you. This will work in our requirement