Calculate the sum of one column based on another column

[Ma_Betancour]

Hello guys,

I'm having issues with a simple measure. I'd like to SUM column MARGIN by OPERATIONS USER only. 

I've tried the following:

a. CALCULATE(SUM('Table'[MARGIN]), ALL('Table' [OPERATIONS USER])) 

b. CALCULATE(SUM('Table'[MARGIN]), FILTER('Table', 'Table'[OPERATIONS USER]))

But neither one of the has given me the right results.

Thanks in advance!

[Anonymous]

I have a similar issue. However, in my case, and to use this example, I want to select distinct operations users.

[v-shex-msft · Accepted solution]

HI @Ma_Betancour,

You can try to use the following measure formula if it meets for your requirement:

Measure =
CALCULATE (
    SUM ( 'Table'[MARGIN] ),
    ALLSELECTED ( 'Table' ),
    VALUES ( 'Table'[OPERATIONS USER] )
)

If above not help, please share some sample data to test:

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Omega]

Hi, 

Try the below measure: 

CALCULATE(SUM('Table'[MARGIN]), ALLExcept('Table','Table' [OPERATIONS USER]))