Matrix column order with Calculation Groups (Measures grouped under Calculation Items instead of the

rampie Hey,

Short answer: Not supported directly.

But you can use In a Matrix, anything in Rows/Columns forms the outer hierarchy; “Values” (measures) are always the innermost. A Calculation Group item placed on Columns will always sit outside the measures. You can’t flip that natively.

Workarounds
1) Best bet : Measure Field Parameter (puts measures on Columns, then nest Calc Group under them)

• Modeling > New parameter > Fields > Measures. Add your base measures (Traffic, Net Sales, Orders…).
• In the Matrix:

- Columns: [Measure Parameter] first, then your Calc Group (e.g., Time Intelligence[Name]) second.
- Values: the auto-generated parameter measure (e.g., [Measure Parameter Value]).

• Result: Columns = Measure → Calculation Item (your desired order).
• Tips: Use the Calc Group Ordinal to control Date, Vs LY%, etc. Reorder the parameter entries to control measure order.

2) If rows are acceptable: Show measures first on Rows

• Put the Calculation Group on Rows.
• Turn on Matrix > Values > “Show values on rows”.
• Result: Rows = Measure → Calculation Item (same logic, but on rows).

3) If Field Parameters aren’t available:

• Either duplicate measures per calc item (e.g., CALCULATE([Net Sales], 'Time Calc'[Name]="YTD")), or
• Use multiple matrices side by side (one per measure), aligning headers. Not elegant, but works.

Bottom line: You can’t invert the hierarchy with a Calculation Group alone. Use a Measure Field Parameter to make measures a true column level, then place the Calculation Group beneath it.

Thanks

Haish K 

If I resolve your issue. Kindly give kudos to this post and accept it as a solution so other can refer this.