Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |