Calculate dimension problem

[kkarlste]

Hi

I don't know what is this calculate dimension problem?=sum({$<FunctionalAreaLevel={'Turnover'}>}[TURNOVER Sales of the period])

[adityaakshaya · Accepted solution]

Hi Kalle,

I will suggest you to use this in expression rather putting it into dimension to get the value. There is no problem with the expression.

[kkarlste]

Hi

I want this to be the dimension of the calculation not expression.

Excpression is same =sum({$<FunctionalAreaLevel={'Turnover'}>}[TURNOVER Sales of the period]) .

Is this problem?

[adityaakshaya]

You cannot use Sum in a dimension field until you use aggr function

[kkarlste]

How should this formula go dimensions?=sum({$<FunctionalAreaLevel={'Turnover'}>}[TURNOVER Sales of the period])