Set Expression Involving Another Measure

[cgT]

Hello,

I'm currently trying to calculate a value based relatively on two measures:

PerformanceWeekCommencing

TransactionDate

I am unable to work out the expression that returns the sum(SoldValue) for the PerformanceWeekCommencing for transactions sold within that same week. I'm imagining something like this, which of course doesn't work:

Money(max(aggr(
sum({<TransactionDate= {'>=$WeekStart(PerformanceWeekCommencing)'}>}SoldValue),PerformanceWeekCommencing)))

Can anyone help, please?

Thank you in advance. 

[Chanty4u]

Try this

sum({$<TransactionDate = {">=$(=WeekStart(PerformanceWeekCommencing))<=$(=WeekEnd(PerformanceWeekCommencing))"}>} SoldValue)

[Kushal_Chawda]

@cgT  why you have used max over sum?

[cgT]

So I can find the largest value derived from the sum calculation.

[cgT]

Thanks for this, but it returns only a '0'.

[Kushal_Chawda]

@cgT  could you prepare sample data in excel to explain the scenario?