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 dy...
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?
