Forum Discussion

Anonymous's avatar
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:    
Need Help
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi,  Anonymous 

Could you please tell me whether your problem has been solved?
You can also take a try formula as below:

Measure_category rank final =
VAR tab =
    ADDCOLUMNS (
        SUMMARIZE ( 'Table', 'Table'[Appr Header], 'Table'[Employee] ),
        "Category Rank final", [Category Rank final]
    )
RETURN
    SUMX ( tab, [Category Rank final] )

or 

Measure_category rank final = SUMX(VALUES('Table'[Appr Header]),[Category Rank final])

 

If it doesn't meet your requirement,please share your formula of "Category Rank Pts " for further research.

 

Best Regards,
Community Support Team _ Eason

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago
    Hi. 
    The Category Rank Pts measure below.  
    I am still having trouble summing up measures.
    I tried using AddColumn to store the Category Rank Pts, but still unable to sum them up by employee.
     
    Category Rank Pts =
    VAR currentSubCat = max('Table'[Appr Header])

     

    Return
    SWITCH(
    currentSubCat
    , "PP"
    , RANKX( FILTER( ALL( 'Table' ), 'Table'[Appr Header] = currentSubCat ), CALCULATE( sum('Table'[sumQty]) ),,ASC )*0.6
    , "PA"
    , RANKX( FILTER( ALL( 'Table' ), 'Table'[Appr Header] = currentSubCat ), CALCULATE( sum('Table'[sumQty]) ),,ASC )*0.2
    , "INS"
    , RANKX( FILTER( ALL( 'Table' ), 'Table'[Appr Header] = currentSubCat ), CALCULATE( sum('Table'[sumQty]) ),,ASC )*0.1
    , "PT"
    , RANKX( FILTER( ALL( 'Table' ), 'Table'[Appr Header] = currentSubCat ), CALCULATE( sum('Table'[sumQty]) ),,ASC )*0.1
    )
     
    Thanks!