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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Try this measure

=SUMX(Data,[Category rank final])

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi.

I was looking for the formula for the Category Rank Final as a sum of the Category Rank Pts measures by employee.
I added the Category Rank Pts measure in the thread.  Thanks.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    Try this measure

    SUMX(Data,[Category rank pts])

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi,  Anonymous 

    This is really strange, I may need you to provide a sample pbix file for further research.

     

    Best Regards,
    Community Support Team _ Eason