topic Re: Need help correcting my easy measure in DAX Commands and Tips

Need help correcting my easy measure

RichOB — Wed, 10 Jul 2024 12:43:49 GMT

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

Re: Need help correcting my easy measure

danextian — Wed, 10 Jul 2024 12:51:17 GMT

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

Re: Need help correcting my easy measure

RichOB — Wed, 10 Jul 2024 13:11:45 GMT

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

Re: Need help correcting my easy measure

RichOB — Wed, 10 Jul 2024 13:22:32 GMT

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