Forum Discussion

Puja's avatar
Puja
Icon for Helper III rankHelper III
3 years ago
Solved

Measure Hierarchy

Hello All, Is this measure hierarchy possible to implement ? I have 3 measures for each season. Season 1 Measure 1 Measure 2 Measure 3 Season 2 Measure 1 Measure 2 Measure 3 When user sele...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Puja 

    actully you don't need to cream a calculation group. Simply create a single column disconnected table that contains measure names. Then create a ResultMeasure that uses a SWITCH statement to switch between different measures based on the MeasureName in the current filter context. In the chart place only ResultMeasure in the values and Measures[MeasureName] in the x-axis 

    Measures =
SELECTCOLUMNS (
    "MeasureName",
    { "Measuure 1", "Measuure 2", "Measuure 3" },
    [Value]
)
    ResultMeasure =
SUMX (
    VALUES ( Measures[MeasureName] ),
    SWITCH (
        Measures[MeasureName],
        "Measure 1", [Measure 1],
        "Measure 2", [Measure 2],
        "Measure 3", [Measure 3]
    )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Puja 

actully you don't need to cream a calculation group. Simply create a single column disconnected table that contains measure names. Then create a ResultMeasure that uses a SWITCH statement to switch between different measures based on the MeasureName in the current filter context. In the chart place only ResultMeasure in the values and Measures[MeasureName] in the x-axis 

Measures =
SELECTCOLUMNS (
    "MeasureName",
    { "Measuure 1", "Measuure 2", "Measuure 3" },
    [Value]
)
ResultMeasure =
SUMX (
    VALUES ( Measures[MeasureName] ),
    SWITCH (
        Measures[MeasureName],
        "Measure 1", [Measure 1],
        "Measure 2", [Measure 2],
        "Measure 3", [Measure 3]
    )
)