I have a transaction table in which users of groups A and B send and receive different information (audio, video, text, etc.) from each other.
I am able to count the total amount of interactions sent and received by each group (A and B) but I am stucked when I try to showcase transactions per user in my charts.
For instance, user 82 sends an image to user 78 and user 78 responds sending 6 images and 2 videos (see pbix). I would like to select user 82 and see all the transactions (send and received) for this particular user.
Could you help me in order to calculate this in DAX?
Thank you very much.