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 ,

 

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.