Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
101 | |
73 | |
70 | |
47 |
User | Count |
---|---|
145 | |
106 | |
105 | |
90 | |
65 |