cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

Need 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:

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

1 ACCEPTED SOLUTION
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] )
)
``````

Proud to be a Super User!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
3 REPLIES 3
Helper III

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

Helper III

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

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

Proud to be a Super User!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.