Forum Discussion

cvinas's avatar
cvinas
Frequent Visitor
8 years ago
Solved

Relationship problem

Hi all,   I have the following scenario:                         I am counting the number of interactions from a sender to a destination and viceversa (depending on sender type: ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi cvinas,

     

    If I understand you correctly, the formula below should work in your scenario. :smileyhappy:

    # Started by Circle = 
VAR currentSelectIDOrigin =
    MAX ( ActivityxUser[ID Origin] )
RETURN
    IF (
        COUNTROWS ( ALLSELECTED ( ActivityxUser[ID Origin] ) )
            = COUNTROWS ( ALL ( ActivityxUser[ID Origin] ) ),
        CALCULATE (
            COUNT ( 'ActivityxUser'[Transaction] ),
            'ActivityxUser'[Sender] = "CERCLE"
        ),
        CALCULATE (
            COUNT ( ActivityxUser[Transaction] ),
            FILTER (
                ALLEXCEPT ( ActivityxUser, ActivityxUser[Date] ),
                ActivityxUser[ID Destination] = currentSelectIDOrigin
                    && ActivityxUser[Sender] = "CERCLE"
            )
        )
    )

     

    Regards

cvinas's avatar
cvinas
Frequent Visitor
8 years ago

Hi v-ljerr-msft,

 

I changed the formula and now,  no value is plotted:

 

 

 

 

 

 

 

 

 

 

 

 

 

If needed, I can upload the .pbix file.

 

Thank you very much.

 

Carlos

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi cvinas,

 

Yes, please upload the pbix file, so that I can try to investigate on the issue. Do mask sensitive data before uploading. :smileyhappy:

 

Regards

    • cvinas's avatar
      cvinas
      Frequent Visitor
      8 years ago

      Hi v-ljerr-msft,

       

      Reviewing in more detail the solution, it works partially well. The problem is that the filter ignore the dates that are not equal to the central user dates, which also can contain a response from circle.

       

      For example: Origen User 942 send transactions in days 02/08, 03/08, 04/08 and 14/08: 

       

       

      It receives responses on that days, but also in day 08/08:

       

       

       

      I suppose this is not taken into account in the new formula, that's why it not appears in the graph:

       

      But also, in the aggregation (month -level), the counting is just referenced to the last date (14/08/2017):

       

       

      Started per User is OK,  but, total for Circle is 17, and it is taking the last value for the max date.

       

      I would appreciate any help !

       

      Thank you!

       

      Carlos