Add columns to matrix visual with hierarchy DAX

[ArquimedesP]

Hi guys, I'm trying to add 3 new columns after  the total column at the end of a matrix visual but I haven't being able to get it right.

I have this tables:

Quarters (no conected table)                                  

VW_Depositos_Unicos (example):

And this is their connections:

I use this measure to get this matrix:

Importes_por_Quarters =

VAR Q1= SELECTEDVALUE(Quarters[Value],"I Trim")

VAR Q2= SELECTEDVALUE(Quarters[Value],"II Trim")

VAR Q3= SELECTEDVALUE(Quarters[Value],"III Trim")

VAR Q4= SELECTEDVALUE(Quarters[Value],"IV Trim")

VAR Q5= SELECTEDVALUE(Quarters[Value],"Total")

VAR _Q1= CALCULATE(SUM(VW_Depositos_Unicos[Importe]),VW_Depositos_Unicos[Trimestre_Vencimiento]="1Q")

VAR _Q2= CALCULATE(SUM(VW_Depositos_Unicos[Importe]),VW_Depositos_Unicos[Trimestre_Vencimiento]="2Q")

VAR _Q3= CALCULATE(SUM(VW_Depositos_Unicos[Importe]),VW_Depositos_Unicos[Trimestre_Vencimiento]="3Q")

VAR _Q4= CALCULATE(SUM(VW_Depositos_Unicos[Importe]),VW_Depositos_Unicos[Trimestre_Vencimiento]="4Q")

VAR _Q5= SUM(VW_Depositos_Unicos[Importe])

RETURN

IF(HASONEVALUE(Quarters[Value]),IF(Q1="I Trim",_Q1,IF(Q2="II Trim",_Q2,IF(Q3="III Trim",_Q3,IF(Q4="IV Trim",_Q4,_Q5)))),_Q5)

And this is my values:

How should I change the Measure to add columns and respect the Hierarchy??

Thanks.

[lbendlin · Accepted solution]

@ArquimedesP You cannot add columns after the totals.  You can remove the totals and create your own custom matrix 

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...