Problems with last three month on a measure

[Anonymous]

Hello everyone,

I have a tabular cube (it is the same problem in Power BI) which looks like follow:

I want to be able to summarise the last three months and get the result 88279,43431

which is the correct result.

The measure M SEK Multilpied is a measure itself - M SEK Multiplied:=

CALCULATE('Loan Original'[Sum of M SEK] * 'Loan Original'[Sum of M SEK])

Loan Original'[Sum of M SEK] is a column.

I have tried several different ways to summarise the values but it does not succeed. What I get is the same result as totalsumma.

For example I tried this measure but it does not work.

M SEK Multiplied ALLSELECTED:= CALCULATE('Loan Original'[M SEK Multiplied];ALLSELECTED('Date'[Year_Month]))

Best regards Marie

[Anonymous]

What's this?

M SEK Multiplied:= CALCULATE('Loan Original'[Sum of M SEK] * 'Loan Original'[Sum of M SEK])

You think this is a measure? 'Cause I think this is just rubbish. First of all, CALCULATE is a function that does either context transition or changes filters. Secondly, you cannot put a naked column (or its square) under CALCULATE without some kind of aggregation.

No wonder it does not work...

Best
Darek