Forum Discussion

MP_123's avatar
MP_123
Microsoft Employee
10 years ago
Solved

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...
  • MattAllington's avatar
    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