SUM VALUES BASED ON A DISTINCT VALUE ON ANOTHER COLUMN

[Anonymous]

Hi all, 

I am sure you guys already resolved similar questions. 

I am looking at the following table (this is just a sample). I want to SUM the Rate_VS_Tipo and DISTINCT by Processo_SGC. 

What I want to achieve is get the SUM of the Rate, for each Processo_SGC where Processo_SGC must be a unique SUM. Meaning, in the below example the result would be 25,9. I am only getting the sum of all of them. Cheers

This isnt working: 

Preço (€) Distinct =

CALCULATE(SUM(t_Detalhe_Processos_Fases_Tarefas[Rate_VS_Tipo]);

FILTER (DISTINCT(

't_Detalhe_Processos_Fases_Tarefas');

't_Detalhe_Processos_Fases_Tarefas'[Rate_VS_Tipo]

)

)

[v-juanli-msft]

Hi @Anonymous

you create a column as below, right?

I create a measure as above, is this what you want?

Measure = CALCULATE(SUM(Sheet2[col2]),FILTER(DISTINCT(Sheet2),[col1]=MAX([col1])))

If not, please let me know your expected result based on my example.

Best Regards

Maggie

[Anonymous]

Hi Maggie, 

Thank you so much!! I think that we got to the result, yes! 

Now, I'd like to add this filter, can you plesase let me know how I could possibly do this: 

FILTER (

't_Detalhe_Processos_Fases_Tarefas';

't_Detalhe_Processos_Fases_Tarefas'[Tipo_Processo_SGC]

IN {"INC1";"INC2"}

)

[v-juanli-msft · Accepted solution]

Hi @Anonymous

Try this measure

Measure =
CALCULATE (
    SUM ( Sheet2[col2] ),
    FILTER (
        DISTINCT ( Sheet2 ),
        [col1] = MAX ( [col1] )
            && Sheet2[Tipo_Processo_SGC] IN { "INC1", "INC2" }
    )
)

If it doesn't work, please share the screenshot when you apply this measure in the table

Best Regards

Maggie

[Anonymous]

Fantastic! 

Thank you very much. 

[Anonymous]

+++ And then I would like to filter it as well.