Modify Existing Created Measure to include Created Variable

[AW1976NOVA]

Hi,

I have a created measure that is working correctly.  However, I need to create an additional Created Measure that calculates something slightly different.  I want to take the existing Created Measure and modify it to accomplish this new requirement.  Here is the current created measure as a basis point:

Employer Group ER Cost = sumx(values('Data Files'[MBR_ID]),calculate(max('Data Files'[ER_Cost])))

This measure calculates the Sum of [ER_Cost] for each [MBR_ID].

I now need to create a new measure that is slightly different.  I need to incorporate a FILTER where the [Source Date] field is the latest date.

I think the best way to do this would be to first create the variable I need to bring in as the FILTER.  Here is that portion:

Latest Date = VAR __MaxDate = MAX([Source Date])

I need to bring the __MaxDate variable in as a FILTER for my original Created Measure:

Employer Group ER Cost = sumx(values('Data Files'[MBR_ID]),calculate(max('Data Files'[ER_Cost])))

...but there is simply too many things going on with this measure for me to understand how to properly bring __MaxDate in as a FILTER.

Can you please help,

Andrew

Thank you!!!!

[v-shex-msft]

Hi @AW1976NOVA,

I think your raw formula not suitable to nested with other functions. (normal we will use the simple aggregate formulas raw formula to nested and used on other formulas)
You can take a look at the following blog to know more about how to nested multiple forums:

Optimizing DAX expressions involving multiple measures 

Regards,

Xiaoxin Sheng