Forum Discussion
Summarizing rows with one baseline row
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!
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
2 Replies
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+thisSumCostIt worked like a charm.
Thanks a lot!
