Total value of table wrong based on summarized rows

Question

Hi everybody! May someone help me with dax formula for this problem please? I tried so much but i cant resolve that...

I have this table with three columns (MATRICULA, PONTOS, ID). My objective is to create a dax formula that sum the total amount of PONTOS of the last interview of a client (highest ID_ENTREVISTA) for each client (MATRICULA_BENEFICIARIO).

So the formula should return: 40 + 25 + 0 +80 + 90 + 100 = 335

I tried this dax fórmula:

and it partially worked:

The formula brings the last interview of each client, but doesnt sum correctly. Instead of "90" the total should be "335".
I tried alot of different formulas but i cant get the correct sum.

May someone help me please?

barritown · Answer

Hi&nbsp;GuilhermeDoeli,If it is okay to replace BLANK with a zero, you can use the approach below:In plain text:MEDIA Pontos totals = 
VAR _tbl = SUMMARIZE ( 
            data, data[BENEFICIARIO],
            "Totals", 
            VAR CurrentBENE = [BENEFICIARIO]
            VAR MaxID = MAXX ( FILTER ( data, data[BENEFICIARIO] = CurrentBENE ), [ID] )
            RETURN MINX ( FILTER ( data, data[BENEFICIARIO] = CurrentBENE &amp;&amp; data[ID] = MaxID ), [Pontos] ) )
VAR Res = SUMX ( _tbl, [Totals] )
RETURN COALESCE ( Res, 0 )Best Regards, AlexanderMy YouTube vlog in EnglishMy YouTube vlog in Russian&nbsp;

devanshi · Answer

Total = SUMMARIZE(Tablename, " ",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM([&nbsp;PONTOS&nbsp; PPS]), ALLEXCEPTED(Tablename,[MATRICULA],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [ID_ENTREVISTAID_ENTREVISTA] = MAX([ID_ENTREVISTA]))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)

Forum Discussion

Total value of table wrong based on summarized rows

2 Replies

Related content

Parameter in summarize

SUMMARIZE, VALUES, and other table generation/manipuation with field parameters

Don't Summarize....still summarizes...?

Summarize Total

calculate with summarize vs values