Forum Discussion

czaldumbide's avatar
czaldumbide
Helper II
6 years ago
Solved

Fixing table relationships

Hello Everyone,   The current relationships among my tables are not alloiwng me to derive a table visualization with my desired output. Let me walk you through my tables and what I've got so far so...
General Comment
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi czaldumbide ,

     

    Try to refer to the .pbix file.

    .pbix 

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi czaldumbide ,

 

Like this? Maybe you can try again.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • czaldumbide's avatar
    czaldumbide
    Helper II
    6 years ago

    Hi v-lionel-msft ,

     

    Thanks for the suggestion. I currently do have that relationship between Accounts and Transactions Table, but I saw you did get the right end product. Could you please attach the pbix file so I can take a look at how you did it?

     

     

     

     

  • czaldumbide's avatar
    czaldumbide
    Helper II
    6 years ago

    v-lionel-msft ,

     

    In the snapshot you provided I don't see how you use Risk Accounts to filter the table. If you could provide a little more information on how you did it I would appreciate it. 

     

    Thanks!

     

    • v-lionel-msft's avatar
      v-lionel-msft
      Community Support
      6 years ago

      Hi czaldumbide ,

       

      Sorry for the late reply. The reason why I don’t use the User table and the Risk Accounts table is because I think they are meaningless.

      .PBIX  

       

      Best regards,
      Lionel Chen

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • czaldumbide's avatar
        czaldumbide
        Helper II
        6 years ago

        Hi v-lionel-msft ,

         

        Thanks for your response. I provided a bad example of my transactions table. If you use the following instead, then you will see why you need to include the Risk Accounts Table. You need a way to filter out Account ID #4 from your final output.

         

        4) Transactions Table

        Account IDAmount
        1$50
        1$100
        2$50
        3$40
        4$100
        5$70
        6$10

         

        Let me know if you can figure it out now.