Calculate Transactions per user

DAX DAX Calculations
1

Question.pbix (1.2 MB)
Transactions.csv (829.0 KB)

Hi Fellow Power BI Users -

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.

Carlos

2

Question2.pbix (1.6 MB)

Hi Carlos,

Gave you something that is very close to what your after by creating a unique list based on your transnational table for both source and destination. In the attached if you select 82 as a origin ID you see what they’ve received from everyone else.

What I’ve done is more of a data modelling trick not a DAX fix, someone might be able to do a DAX one.

PBiX attached.

This help

3

Hi,

When you use the date from the dates table and apply both directions on the relationship, you are close I guess.

Paul

4

Hi Sgtlumex and Paul,

Thanks for your answer. I’ve opened the file but I am not able to see the results:

Example
Example.PNG1920×1008 87 KB

I would like to show interactions for whatever user, let’s say 82, but without selecting all users implied in the Origin ID (i.e. just selecting 82) or in the Destination ID.

image
image.png1920×1023 99.9 KB

The picture above shows the correct behaviour I would like to obtain for selecting user 78 or 82.

Is there any way to create a measure that solve this issue?

Thank you very much.