Using measures in column formula

[Apple08]

Hi

I have done some measure calculations to work out the total of Project A actual:

Project A Actual = calculate(sum([Actual]),[project_name]="ProjectA",or([task_name]="TaskA",[task_name]="TaskB"))


Project A Budget = CALCULATE(sum([Original Budget]),[task_name]="ProjectA",[Unit]="A")


Both of the above measure works, however I would like to use this measure in a column calculation below:

Column
NewActuals = if(and([task_name]="ProjectA", [Unit]="A"),[Project A Actual]*[Original Budget]/[Project A Budget], 0)

However, no value is returned in this column. I wonder can I use measures in column calculation formula? Please could anyone help to point out my mistakes. Many thanks.

 

[Matt Allington]

Yes you can use measures in columns, but chances are it is not the best approach. It is a massive topic. The bigger question is, “why do you want to add a column”? Mostly you don’t need to do this.

 

[Apple08]

Thanks Matt for your response. The reason I need to include measure calculation in a new column because I need to show the break down of project actuals together with other columns of forecast and budget. Therefore I need the breakdown of actuals attached with each project on each row. However I am unable to use the measure in the new column formula. Please could you point me to the right direction.

 

[Apple08]

Also, I have tried to use = calculate function in a new column, however it doesn't allow me to choose the table parameters but it only showed me the list of measures. I might have done something wrong?