Need help correcting my easy measure

[RichOB]

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:

Major = CALCULATE(SUM('Table'[Clientcount]), 'Table'[Severity]="Major")

Here's my data set:

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

[RichOB]

Hi @danextian thanks for getting back to me. I tried that but it's giving me this error. Any ideas why?

[RichOB]

@danextian ah the numerical type was text, not a number. Thanks for your help the measure works perfectly!

[danextian · Accepted solution]

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] )
)