I know I can do this (quick example off the top of my head):

```
WITH
Member Measures.AnotherDataColumn AS [MyDimension].CurrentMember.Properties("MyProperty")
SELECT
{
Measures.DataColumn,
Measures.AnotherDataColumn
} ON COLUMNS
{
[MyDimension].Item
} ON ROWS
```

But is there a way to include that same calculated member `Measures.AnotherDataColumn`

in the ROWS dimension?

Thanks in advance!!

## Best Solution

You can create calculated members in any dimension, not just the measures dimension, but then you need to tell SSAS how you want it to aggregate the measures. Typically this is aggregating a set of other members from the same dimension and you see something like the following using the Aggregate function: