Measure Hierarchy

[Puja]

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 · Accepted solution]

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

[Mahesh0016]

@Puja Please go through this i hope this  helps you 
#First Link for bar Chart
https://youtu.be/UnG0u8J0pSc
https://youtu.be/2y2VP6i8S8c


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you!!