Using sumx to sum same categories listed in rows within a table

[Nanakwame]

Hi Experts,

I have a table with different departments  listed as rows and a value for each. I am trying to have dax sum all values by department. I understand sumx can help achieve this result. Any idea how i can use sumx to sum the different departmants?

Thank you 

[V-lianl-msft]

Hi @Nanakwame ,

Try measure like:

measure = SUMX(VALUES('Table'[departments  ]),[total])

If the problem still exists, please provide sample data and expected results so that we can better understand your scenario.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Nanakwame , If you want to have a department in visual, then even a simple sum would do.

Unless you have to do some row level operation, you can avoid using SumX function

refer

https://radacad.com/sum-vs-sumx-what-is-the-difference-of-the-two-dax-functions-in-power-bi

[Nanakwame]

HI @amitchandak 

I am trying to do a row level calculation to sum each department sales and use it in another calculation. so i am experting to row level calc to summarize the table and sum all departemnts belonging to each other