Forum Discussion
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, not the original measures from the sample. why is that?
thanks a lot
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
1 Reply
- MattAllingtonCommunity 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