SUM of values for each category

[Anonymous]

Hello,

I have a table like this one :

category	number
cat_1	5
cat_2	6
cat_2	3
cat_1	1
cat_3	8

And I want to calculate the sum of number for each category, so :

category	sum
cat_1	6
cat_2	9
cat_3	8

My final aim is to perfom a TOPN to get the N categories with the highest sum.

Any idea to do this stuff ?

Thank you

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

You can achieve it by TopN filter in Filters pane just as below screenshot:

TOP N Filter in Power BI with Zero DAX Code; Visual Level Filter

Best Regards

[amitchandak]

@Anonymous , Sum does not seem right to me

for TOPN Try

CALCULATE(Sum(Table[Number]),TOPN(2,all(Table[Category]),CALCULATE(Sum(Table[Number])) , DESC),VALUES(Table[Category]))

TOPN: https://youtu.be/QIVEFp-QiOk