Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How can I make filtering work between these tables?

Basically I want to filter to see the sales per call duration(Calls table). With the existing data model, when I try to visualize the data it gives me the wrong values as seen below. I have co...
Need Help
PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 

You dont have Call Duration data in your Sale Table, so you put relationship on User Code. So user code filter the Sale Table and shows same Sale Value for both Call Duration for One User
See details

 

If you have User Code and Call Duration column in your Sale Table, please CONCATENATE User Code and Call Duration in both Call Table and Sale Table, after create relation on CONCATENATE column.

Attached PBIX

If you have question, please feel free to let me know.
If your requirement is solved, mark this comment as SOLUTION
If this comment helps you, Please LIKE this comment / KUDOS

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi PijushRoy 

     

    Thank you for the response, so am I supposed to merge Sales table with calls table so I can get call duration column in Sales table?