Forum Discussion

Puja's avatar
Puja
Helper 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 selects Season 1  I want to   3 measures selected in the BAR chart. 

Is it possible ?

 

Thanks 🙂

  • 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]
    )
)

2 Replies

  • tamerj1's avatar
    tamerj1
    Community 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]
    )
)