Sumar el total de los valores máximos de la tabla

Sebaskas — Thu, 18 Jul 2024 18:24:18 GMT

Tengo la siguiente tabla en la cual son los valores maximos de cada columna, en el cual requiere la suma de esos valores en el TOTAL

Re: Sumar el total de los valores máximos de la tabla

Anonymous — Fri, 19 Jul 2024 07:00:40 GMT

Hi,Sebaskas

I am glad to help you.

According to your description, you want to add the total of the maximum values in the table?

If I understand you correctly, then you can refer to my solution.

Since you didn't give me some test data, I created a simple dataset myself:

Then create a Measure to calculate the sum of the maximum values and put the Measure into the matrix or Card:

SumOfMaxMonthlyTotals = VAR _vtable1 = SUMMARIZE ( 'Table2', 'Table2'[TPARENT], 'Table2'[Date], "_Sum", CALCULATE ( SUM ( 'Table2'[Value] ), FILTER ( ALLSELECTED ( Table2 ), 'Table2'[TPARENT] = EARLIER ( Table2[TPARENT] ) && MONTH ( 'Table2'[Date] ) = MONTH ( EARLIER ( 'Table2'[Date] ) ) && YEAR ( 'Table2'[Date] ) = YEAR ( EARLIER ( Table2[Date] ) ) ) ) ) RETURN SUMX ( SUMMARIZE ( _vtable1, [TPARENT], "_MAX", MAXX ( FILTER ( _vtable1, [TPARENT] = EARLIER ( Table2[TPARENT] ) ), [_Sum] ) ), [_MAX] )

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,
Fen Ling,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Sumar el total de los valores máximos de la tabla in DAX Commands and Tips

Sumar el total de los valores máximos de la tabla

Re: Sumar el total de los valores máximos de la tabla