Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I don't know what is this calculate dimension problem?=sum({$<FunctionalAreaLevel={'Turnover'}>}[TURNOVER Sales of the period])
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.
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.
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?
You cannot use Sum in a dimension field until you use aggr function
How should this formula go dimensions?=sum({$<FunctionalAreaLevel={'Turnover'}>}[TURNOVER Sales of the period])