Sum a measure last 4 week

[Anonymous]

Im stuck with one things and that is that i want to Sum an measure.

What im trying to do is sum a measure last 4 weeks. And that have been easy with values that arent a measure, yet.
For example im counting member id:s from a table i have where we look into how many customers have answered our questions about make a better webbsite.

My measure for that is:

Last 4 weeks customers =
CALCULATE (
COUNT(NPS_Privat[Member ID]);
DATESINPERIOD(Date[Date];LASTDATE(Date[Date]);-28;DAY)
)
This works fine, but when i try to use a measure then it doesnt.
My measure is:
NPS = ([Customers answered 9-10] - [Customers answered 0-6])*100

and what i want to do is this measure:
CALCULATE (
[NPS];
DATESINPERIOD(Date[Date];LASTDATE(Date[Date]);-28;DAY)
)

And this doesnt work.

Do anyone have any solution for being able to sum a measure last 4 weeks?

Thanks in advance

[v-yuta-msft · Accepted solution]

@Anonymous ,

You need to convert measure below to calculate column:

NPS = ([Customers answered 9-10] - [Customers answered 0-6])*100

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.