Forum Discussion
Post PartisanNeed help correcting my easy measure
Hi, I need Major, Minor, and Moderate to be their own measures if possible so I can use those details in other calculations. But first I need to isolate them.
I could have sworn I've made a measure kind of like this before, but it doesn't work so something must be wrong:
| Name | Severity | Clientcount |
| Dave | Major | 1 |
| Mark | Minor | 1 |
| Phil | Moderate | 1 |
| Stacey | Major | 1 |
| Emily | Major | 1 |
| Anna | Major | 1 |
Is there a measure that can isolate each severity type and the number of Clientcount that belong to that severity type like this?:
Measure 1: Major = 4
Measure 2: Minor = 1
Measure 3: Moderate = 1
Thanks
Hi RichOB ,
Your measures seems to be correct already. Putting that Major measure in a table with all those other fields will show the Major measure total regardless of the severity value in the current row. If you want to show just for major when it is the current value, you can use:
Major = CALCULATE ( SUM ( 'Table'[Clientcount] ), KEEPFILTERS ( 'Table'[Severity] = "Major" ) )If you want the total for each without using separate measures:
Major = CALCULATE ( SUM ( 'Table'[Clientcount] ), ALLEXCEPT( 'Table', 'Table'[Severity] ) )
3 Replies
- danextian
Super User
Hi RichOB ,
Your measures seems to be correct already. Putting that Major measure in a table with all those other fields will show the Major measure total regardless of the severity value in the current row. If you want to show just for major when it is the current value, you can use:
Major = CALCULATE ( SUM ( 'Table'[Clientcount] ), KEEPFILTERS ( 'Table'[Severity] = "Major" ) )If you want the total for each without using separate measures:
Major = CALCULATE ( SUM ( 'Table'[Clientcount] ), ALLEXCEPT( 'Table', 'Table'[Severity] ) )
