Add columns to matrix visual with hierarchy DAX

ArquimedesP — Wed, 07 Jul 2021 21:21:30 GMT

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.

Re: Add columns to matrix visual with hierarchy DAX

lbendlin — Mon, 16 Aug 2021 13:45:10 GMT

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