Forum Discussion
Nanakwame
4 years agoHelper II
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...
V-lianl-msft
4 years agoCommunity Support
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.