Forum Discussion

swwong1's avatar
swwong1
Helper III
5 years ago
Solved

Relationship Between Data Table and Virtual Table

Hi All   My transactional data is on a project level by client and I have used SUMMARIZECOLUMNS to calculate the total revenue by client. However since there is no relationship, the filters aren't...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, swwong1 

    Please correct me if I wrongly understood your question.

    I do not know the situation that is related to this data model well, but,

    in my opinion, I prefer to create a relationship and drag the ClientGroup Column Not from Data Table, but from Client Data Table.

     

    Please check the link down below.

     

    https://www.dropbox.com/s/yy60lo6pjc9naqs/SampleFile.pbix?dl=0 

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, swwong1 

Please correct me if I wrongly understood your question.

I do not know the situation that is related to this data model well, but,

in my opinion, I prefer to create a relationship and drag the ClientGroup Column Not from Data Table, but from Client Data Table.

 

Please check the link down below.

 

https://www.dropbox.com/s/yy60lo6pjc9naqs/SampleFile.pbix?dl=0 

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

  • swwong1's avatar
    swwong1
    Helper III
    5 years ago

    Thanks Jihwan_Kim 

     

    This is what I want, but strangely it didn't work when I was doing it at work (for a more complicated dataset). Seems like this relationship didn't connect properly.

     

    Let me test it our at work using this approach again