Forum Discussion

Rovisonn's avatar
Rovisonn
Frequent Visitor
6 years ago
Solved

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....
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Rovisonn
    Frequent Visitor
    6 years ago

    It worked like a charm.

     

    Thanks a lot!