Dynamic SUMX

[mb0307]

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 

[v-yalanwu-msft]

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.

[mb0307]

Any solution for this problem please?

[parry2k]

 what is the expression of your following measure?ABS( [DiffCalculation] )

@mb0307

[mb0307]

@parry2k  that is the difference between Sales - Forecast.  ABS to convert any -ve to +ve.

Sales and Forecast are two tables, connected to Master Table by Product Number.

Thanks

[parry2k]

@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.

[mb0307]

@parry2k 

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?

[parry2k]

@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.

[mb0307]

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.