Forum Discussion
Using sumx to sum same categories listed in rows within a table
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. A...
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
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
