Calculate percentage based on columns of two separate tables

[Anonymous]

i have two separate tables connected by a common column. i want to calculate percentage based on two columns one from each of these columns but i am unable to get correct values when creating a new coulmn with formula in 2nd table.

when i am selecting column from table and selecting sum in its properties then it is giving correct results.

but when i am using formula to create custom column then it is giving incorrect details. below is the formula

below is the table

i want to have same value for "column 2" which is of EAC for all the rows. is there any way to achieve this?

[amitchandak · Accepted solution]

@Anonymous , I think it should a new Measure. I doubt you create a new column

[Anonymous]

@amitchandak Thanks...Measure worked. can you please let me know when we should go with Measure and when we should go with Column?

[amitchandak]

@Anonymous , Calculated column basically becomes part of your table and that will be calculated each time after data load at row level.

You can any assume like  Excel column formula

Whereas Measure is calculated at run time and the context of the row is based on data getting grouped

Pivot table calculation

Refer this document

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/