Forum Discussion
Anonymous
3 years agoNot applicable
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...
- 3 years ago
Anonymous
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
Super User
3 years agoAnonymous 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!!