Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to view underlying relationships generated by Power BI

 

Hi everyone, I want to answer this question in Power BI but not sure about the right way to do it.

 

I want to have 2 tables of

 

  • Count of Orders | Country of Merchants
  • Count of Orders | Country of Users

When I drag the country's name field, I don't know where is it come from?

 

Thanks,

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Not entirely sure what you are asking. There is a relationships tab in Power BI Desktop, third icon down on the left that shows relationships. Your country name should come from your Country table and assuming that your relationships are correct you could then just use a Count of your orders[id] I would presume.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

       

      Here are the screenshots, how can I get these 2 tables in the same view

      - Count of Order.ID | Cities of Merchants

      - Count of Order.ID | Cities of Buyers

       

      Thanks,

      • v-piga-msft's avatar
        v-piga-msft
        Icon for Resident Rockstar rankResident Rockstar
        7 years ago

        Hi Anonymous,



         

         

         Here are the screenshots, how can I get these 2 tables in the same view

        - Count of Order.ID | Cities of Merchants

        - Count of Order.ID | Cities of Buyers

         

        What about changing the cross filter direction between table orders and the table order times to be Both?

         

        In addition, I didn't find the where is the column or table about Buyers.

         

        If you still need help, please share your desired output so that we can understand your requirement better and get the solution.

         

        Best  Regards,

        Cherry