Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

First Interaction after Campaign Sent

I have 3 tables. The campaign table is connected to the interactions table by the contact table.

 

Campaign Table

 

Contact Table

 

Interaction Table

 

My current try

FirstInt =

VAR CampaignDate = SELECTEDVALUE('EDW vwTravel'[TransDate])

 

VAR IntAfterCampaign =

    FILTER (

        SUMMARIZE (

            'EDW Interactions',

            'EDW Interactions'[Date],

            "Count",DISTINCTCOUNT('EDW Interactions'[FullMemberShipNumber])

        ),

        'EDW Interactions'[Date] > CampaignDate

    )

 

VAR FirstIntType =

    MINX ( IntAfterCampaign, [Count] )

 

RETURN

FirstIntType

 

My problems with this 

I am getting duplicates by type. (I only want the first type)

The number is interactions is way too low.

 

What I am trying to do

I am trying to calculate the count of the first interaction after a campaign email is sent out. I also want to visualize by type of interaction.

 

How I want to visualize

 

Need Help
  • amustafa's avatar
    amustafa
    2 years ago

    Hi Anonymous 

     

    You can add a new DAX measure in your Interactions table to get the first date. It is dynamic to what you select in the Matrix.

     

    FirstInteractionDate =
    CALCULATE(
        MIN('Interactions'[Interaction Date]),
        ALLEXCEPT('Interactions', 'Interactions'[MemberNumber], 'Interactions'[Type])
    )
     
    Results:

     

    OR 

     

     

1 Reply

  • amustafa's avatar
    amustafa
    Solution Sage
    2 years ago

    Hi Anonymous 

     

    You can add a new DAX measure in your Interactions table to get the first date. It is dynamic to what you select in the Matrix.

     

    FirstInteractionDate =
    CALCULATE(
        MIN('Interactions'[Interaction Date]),
        ALLEXCEPT('Interactions', 'Interactions'[MemberNumber], 'Interactions'[Type])
    )
     
    Results:

     

    OR