Calculated column formula in a row context

[Gordonik]

Hi

My simplistic data model looks like this:
[TABLE="width: 252"]
<colgroup><col span="2" width="64" style="width: 48pt;"><col width="108" style="width: 81pt;"><col width="16" style="width: 12pt;"></colgroup><tbody>[TR]
[TD="width: 64"]Table.1[/TD]
[/TR]
[TR]
[TD]Spread[/TD]
[TD]Product[/TD]
[TD]Sales Channel[/TD]
[TD]..[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]x[/TD]
[TD]CB[/TD]
[TD]..[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]y[/TD]
[TD]CB[/TD]
[TD]…[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]x[/TD]
[TD]GFR[/TD]
[TD]..[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]y[/TD]
[TD]GFR[/TD]
[TD]..

[/TD]
[/TR]
</tbody>[/TABLE]
I need a calculated column with Spread Mapping, which should look like this:

->There are more columns in data model.
-> Spread for GFR is wrong so it must be mapped to be able to compare with CB
I guess there should be calculated column formula to calculate Spread Mapping.
Any idea how to do it?
I have tried this: (not working as I expected)


=CALCULATE(sum([Spread]);FILTER(ALL('Table.1'[Sales Channel]);Table.1[Sales Channel]="CB"))


Spread Mapping = Spread for CB
but for GFR we are looking for adequate values in CB (means: all conditions the same, except Sales Channel)