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

  • nbitabc's avatar
    nbitabc
    Helper I
    4 years ago

    Hi v-yalanwu-msft ,

     

    Sorry if my explaination was not clear earlier.

     

    Here is an example file with the scenario -

    In the data model, you can see Office Location and Region are two different dimension tables and have no direct link between them. 

    Related_Example_pbix 

     

     

     

    Here is mockup desired output -

    Desired_Output 

    Need to create the Combined Office Loc-Region field in PowerBI report that can used with both Sales Fact and Inventory fact tables

     

     

    Hope this clears this clears it up. Thanks for your help.