Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculated table with additional calculated column

Dear Group,   I would like to create a table that will be based on Union as below:   Ranking = Var _Plant1 = CALCULATETABLE(SUMMARIZE('For Plants','For Plants'[Customer],'For Plants'[Plant abb]...
  • bhanu_gautam's avatar
    2 years ago

    Anonymous , Without creating multiple intermediate tables, you can use a single DAX expression that combines the steps. 

     

    Ranking =
    VAR _AllPlants =
    CALCULATETABLE(
    SUMMARIZE(
    'For Plants',
    'For Plants'[Customer],
    'For Plants'[Plant abb],
    "Sum of act", SUM('For Plants'[Actuals in LC])
    )
    )

    VAR _RankedPlants =
    ADDCOLUMNS(
    _AllPlants,
    "Rank", RANKX(
    FILTER(_AllPlants, 'For Plants'[Plant abb] = EARLIER('For Plants'[Plant abb])),
    [Sum of act],
    ,
    DESC,
    DENSE
    )
    )

    RETURN _RankedPlants