First Interaction after Campaign Sent

[Anonymous]

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

[amustafa · Accepted solution]

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