Forum Discussion
MP_123
10 years agoMicrosoft Employee
problem with creating a measure
hi all, following the pront screen attach. i'm creating a report ewith the financial sample, as you can see, when i want to create a new measure, i can use only measure i created before, no...
- 10 years ago
It is because the formula you are writing ONLY supports a measure OR a column with an aggregator wrapped around the column name - such as SUM(). You haven't used an aggregator, hence the only valid choices there are must be to use a measure.
If you type the following, you will see it will work
=CALCULATE(SUM(finan
MattAllington
10 years agoCommunity Champion
It is because the formula you are writing ONLY supports a measure OR a column with an aggregator wrapped around the column name - such as SUM(). You haven't used an aggregator, hence the only valid choices there are must be to use a measure.
If you type the following, you will see it will work
=CALCULATE(SUM(finan