topic Re: Measure Hierarchy in DAX Commands and Tips

Measure Hierarchy

Puja — Fri, 28 Apr 2023 21:09:48 GMT

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 🙂

Re: Measure Hierarchy

Mahesh0016 — Sat, 29 Apr 2023 05:39:26 GMT

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!!

Re: Measure Hierarchy

tamerj1 — Sat, 29 Apr 2023 10:00:28 GMT

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