Sum function depending other columns

[blackcat18]

Hi every one,

I am starting to use DAX Expression in Power Pivot. i would like to know how I could summarize a column depending another.
Like =sum([CA]) where [ID] has the same value.

I think it is a simply formula but I did not find how to write it. I was trying:

=CALCULATE(sum([CA]);ALL(RPT_PerformanceBuvette_CA_Total[OPFSessID]))

but the result is exactly the number in the [CA] cell.

Regards

 

[Tianbas]

it seems todays questions can be answered all with the same formula

=calculate(sum(RPT_PerformanceBuvette_CA_Total[CA),filter(RPT_PerformanceBuvette_CA_Total,RPT_PerformanceBuvette_CA_Total[OPFSessID]=earlier(RPT_PerformanceBuvette_CA_Total[OPFSessID])))

 

[propi_]

it seems todays questions can be answered all with the same formula

=calculate(sum(RPT_PerformanceBuvette_CA_Total[CA),filter(RPT_PerformanceBuvette_CA_Total,RPT_PerformanceBuvette_CA_Total[OPFSessID]=earlier(RPT_PerformanceBuvette_CA_Total[OPFSessID])))

haha seems so everybody say calculate() ist the ultimate thing...but the car won't drive without the engine