Forum Discussion
Dynamic SUMX
Hi guys,
DAX below just works fine on a single column (Product):
RowSum =
SUMX(
VALUES( dimMaster[Product] ),
ABS( [DiffCalculation] )
)
How can I make this dynamic to sum other columns similarly?
Example: If I have columns like Country, Division, Category etc... then do I need to write same for all the columns separetely or can it be achieved within same code?
Thanks
8 Replies
mb0307 are these columns from the same table?
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Yes. Thanks
Please note that I do NOT want to summarize all cols. I want them to be sum separately, like writing my DAX for each col.
mb0307 change VALUE(DimMaster[Product]) to DimMaster
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Product in rows
Product column - (based on my sumx) works
Master Table column - based on as you suggested solution doesn't show same numbers?
Similarly if I want to drop Country in rows and use my sumx (VALUES( dimMaster[Country] ) then Master Table numbers should match. But it doesn't - any fix please?
Any solution for this problem please?
Hi, mb0307 ;
and can you share a simple data removing sensitive information, along with the results you want to output?
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
