Add row-level TTC total outside column hierarchy in Power BI matrix

[KevinSV]

I have an expenses table with arrears columns by period: ARREARS_0-3_HT, ARREARS_0-3_TVA, ARREARS_3-6_HT, etc.
In Power BI, I’ve unpivoted these columns to create two new columns:

• Period (0-3, 3-6, 6-9, 9+)

• Type (HT or TVA)

My goal is to create a matrix where:

• Columns represent the hierarchy Period → Type.

• Rows are my dimensions (e.g., RAISON, property, etc.).

• I want to add the TTC column as a row-level total, outside of the Period → Type hierarchy.

The problem: when I add TTC directly to the matrix values, Power BI tries to split it according to the column hierarchy, so I don’t see it as a total per row. I want TTC to appear outside the Period → Type blocks.

I tried creating a simple measure SUM(TTC), but it still gets split. I think I need a measure that ignores the column hierarchy, but I’m not sure about the exact syntax or the best way to place it in the matrix.

Here is a screen : 

So I want to add the TTC side of the hierarchy bloc. 
thank you all 🙂 

[Anonymous]

Hi @KevinSV ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. 

Thank you.

[KevinSV]

Hello, I am totally sorry about my no response. I had no access on my work computer during the last week. 
I tried your method and apply on mine and actually worked ! 
Thank you ! 

[Anonymous]

Thank you for your confirmation. I'm glad it helped you resolve your issue. If you need further assistance, please feel free to reach out to the Fabric community forum.

[Anonymous]

Hi @KevinSV ,

I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.

Thank you.

[Anonymous · Accepted solution]

Hi @KevinSV ,

Thank you for reaching out to the Microsoft fabric community forum.

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used sample data on my end and successfully implemented it.     

I am also including .pbix file for your better understanding, please have a look into it:

Hope this helps, Please feel free to reach out for any further issues.

Thank you .

[Shahid12523]

To show TTC as a separate column outside the Period → Type hierarchy in your Power BI matrix:
- Create a disconnected table with one value: "TTC".
- Build a measure like TTC_Display = IF(SELECTEDVALUE(DisplayColumns[Display]) = "TTC", SUM(Expenses[TTC])).
- Use this table as your column header in the matrix, alongside your existing hierarchy.

[KevinSV]

Hello Shahed Shaikh, 
I tried the technique of creating a disconnected table “DisplayColumns” with a single value “TTC” and the measure, I obtain this 

in my matrix where I already have the Period → Type hierarchy.

Unfortunately, it doesn’t work as expected: TTC appears for every Period → Type block, so next to Montant, instead of being a single column outside the hierarchy.

I’m still looking for a way to make TTC appear as a row-level total, independent of the Period/Type columns.