Sum of transactions for a client after an event from another table

[Sibrulotte]

Hi, 

I tried hard to work with Copilot to come up with the proper measure, but I'm turning to real people for help now.

I have a transactions table:

EpargnantSource_Code DateReport_Date Montant

C001	20 septembre 2024	300
C001	10 octobre 2024	200
C002	15 octobre 2024	150
C003	25 décembre 2024	400
C001	10 novembre 2024	250
C003	15 janvier 2025	350 And a telemarketing table listing calls made to those clients: EpargnantSource_codecreatedon C001 15 septembre 2024 C002 1 octobre 2024 C001 5 novembre 2024 C003 20 décembre 2024 And lastly a numeric range with a single value in a slicer from 1 to 60 (representing days after the phone call) called NB_jours_télémarketing. I'm looking to calculate transaction amounts after a phone call was made, within a certain amount of days determined by the numeric value in NB_jours_télémarketing. Copilot insists this should work:   SommeTransactionsApresAppel = VAR NbJours = SELECTEDVALUE('NB_jours_télémarketing'[NB_jours_télémarketing Value]) RETURN SUMX (     'Télémarketing',     VAR DateAppel = 'Télémarketing'[createdon]     VAR CodeClient = 'Télémarketing'[EpargnantSource_code]     RETURN         CALCULATE (             SUM ( TransactionEpargnant[Montant] ),             FILTER (                 ALL ( TransactionEpargnant ),                 TransactionEpargnant[EpargnantSource_Code] = CodeClient                     && TransactionEpargnant[DateReport_Date] > DateAppel                     && TransactionEpargnant[DateReport_Date] <= DateAppel + NbJours             )         ) )     But I have token errors, and and the SELECTEDVALUE('NB_jours_télémarketing'[NB_jours_télémarketing Value]) turns out underlined in red.   Does anyone have a helping brain?

[Sibrulotte]

Works great. What did the ,30 add to the selectedvalue ?

It'S basically the default value?

[mh2587 · Accepted solution]

SommeTransactionsApresAppel := //Try this
VAR NbJours =
    SELECTEDVALUE('NB_jours_télémarketing'[NB_jours_télémarketing Value], 30) 
RETURN
    SUMX (
        'Télémarketing',
        VAR DateAppel = 'Télémarketing'[createdon]
        VAR CodeClient = 'Télémarketing'[EpargnantSource_code]
        RETURN
            CALCULATE (
                SUM ( TransactionEpargnant[Montant] ),
                FILTER (
                    TransactionEpargnant,
                    TransactionEpargnant[EpargnantSource_Code] = CodeClient &&
                    TransactionEpargnant[DateReport_Date] > DateAppel &&
                    TransactionEpargnant[DateReport_Date] <= DateAppel + NbJours
                )
            )
    )