SUMIFS Measure Like DAX to sum by period and category in a table visual

[chudson]

I have a table, example below that I'm trying to create a sum measure that will return The Cumulative Rep Revenue by Month.  The should return column is the expected result from the measure based on the Rep and Month in the Example.

I tried using calculate sum but can't get it to work with the filters.

Can someone help with the DAX measure.

Rep	Product	Month	Revenue	Should Return
Bob	A	2019-01	1000	3000
Bob	B	2019-01	2000	3000
Bill	B	2019-01	500	1200
Bill	C	2019-01	700	1200
Bob	A	2019-02	200	200
Bill	B	2019-02	1200	1200
Bob	A	2019-03	500	2100
Bob	B	2019-03	600	2100
Bob	C	2019-03	1000	2100

[HotChilli · Accepted solution]

A measure

Measure 2 = 
CALCULATE(SUM(Table4[Revenue]), ALLEXCEPT( Table4, Table4[Rep], Table4[Month]))

[chudson]

Hi @HotChilli ,

What if the columns in the visual are from different data tables, not the same table source in the dataset?

Thanks,

[HotChilli]

Measures evaluate according to context so, depending on these other fields, you may get different results.  You might try a calculated column (DAX is not the same but it's close)