Summarizing rows with one baseline row

[Rovisonn]

Hi everyone,

I'm a bit stuck with a DAX issue. I was hoping anyone could help me out with a solution. 

I have a dataset with cities, strategies and cost. The dataset contains over 150 cities. Each city has a baseline strategy and three alternative strategies (rows) with costs (columns). I'm trying to calculate the total costs for each strategy within each city. The issue however is that the costs for each strategy are relative to the baseline costs. 

Below is an excel image I created of a simple dataset and the result I'm expecting. 

Thanks in advance!

[Anonymous · Accepted solution]

It is a fairly simple scenario, but we need to see the model.

If that is simply a single table, you can have a calculated column

Cost Including Baseline=
Var thisCity=Table[City]
var thisSumCost=Table[SumCost]
var BaselineCost=SUMX(Filter(Table;Table[City]=thisCity && Table[Strategy]="Baseline");Table[SumCost])

RETURN
BaselineCost+thisSumCost

[Rovisonn]

It worked like a charm.

Thanks a lot!