Alternative to EARLIER in DAX measure

[PowerBITestingG]

Hi all,

I am trying to obtain a measure that sums the total quantity of Sources that have the same Location. It has to be a measure because the result is dependant on other measures.

So here the first Source England with Location New York, has 8 other Sources with New York, so the expected result is 608+369+359+129+68 etc (notice it skipped India)

Source	Quantity	Location	Expected result
England	608	New York	1633
New York	369	Colombia	369
New York	359	Colombia	359
New York	129	Mexico	129
India	10	USA	96
New York	68	Japan	68
New York	38	Colombia	38
New York	36	Croatia	36
New York	22	China	22
New York	4	Italy	4

Any ideas? 

Before I had all this in excel and I was using:

Expected Result = [Quantity]

+ SUMX (

FILTER ( Table, EARLIER ( Location ) = Source)

[Quantity])

[parry2k · Accepted solution]

@PowerBITestingG try this measure:

Sum Qty = SUM ( Source[Quantity] )

Sum = 
SUMX ( 
    Source,
    VAR __location = Source[Location]
    VAR __value = CALCULATE ( [Sum Qty], ALL ( Source ), Source[Source] = __location )
    RETURN
        __value + [Sum Qty]
)

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.