Forum Discussion

Anonymous

Not applicable

5 years ago

sum a measure with grouping

Hi! Just wondering if this is possible. I am attempting to sum the Category Rank Pts by Employee. Category Rank Pts is a measure. The end result:

Community Champion

5 years ago

Hi Anonymous

use this measure

Category Rank Final_BIS =

VAR _EmployeeID = SELECTEDVALUE('TABLE'[Employee])

VAR _Result = CALCULATE(SUM('TABLE'[Category Rank Final]) , 'TABLE'[Employee] = _EmployeeID)

RETURN

_Result