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]))
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
131 | |
81 | |
65 | |
61 | |
55 |
User | Count |
---|---|
199 | |
104 | |
88 | |
79 | |
77 |