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!
Solved! Go to 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
I have a similar issue. However, in my case, and to use this example, I want to select distinct operations users.
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
Hi,
Try the below measure:
CALCULATE(SUM('Table'[MARGIN]), ALLExcept('Table','Table' [OPERATIONS USER]))
User | Count |
---|---|
136 | |
59 | |
56 | |
55 | |
47 |
User | Count |
---|---|
128 | |
76 | |
55 | |
54 | |
51 |