Create a measure that SUMs based on two other fields in the same row

[seabrew]

I am trying to do this for a median value against the aggregated values of two columns in the same row. Can someone help me with the DAX? I got it to work with SUMMARIZE and CALCULATETABLE, but I need a scalar value in order to work in the Pivot Table / Matrix. I then want to do a MEDIAN function against the new measure. 

Sample data is here. I want to group by Client and AsOfDate to get the Client SUM for the AsOfDate and return that value to each account belonging to the client on the AsOfDate. 

Account	Client	Value	AsOfDate	New Measure - Client SUM Value
123	A	10	5/31/2017	25
234	A	15	5/31/2017	25
658	B	20	5/31/2017	20
98	C	30	5/31/2017	30
123	A	20	4/30/2017	85
234	A	65	4/30/2017	85
658	B	67	4/30/2017	67
98	C	32	4/30/2017	32

[v-huizhn-msft]

Hi @seabrew,

I am still confusing your requirement, could you please list an example to display what you want? How to display each account belonging to the client on the AsOfDate? 

>> I then want to do a MEDIAN function against the new measure. 

You can create a measure using the formula: median=MEDIAN(Table[NewMeasure]). Then show it in a card visual to check if it works fine. For MEDIAN function, please review the blog.

Best Regards,
Angelia