Forum Discussion
Formula calculation not working
Hello,
I have a matrix visual that all data points are correct except for my last column called "Total Sales Diff Per Week".
The answer for the top row should be the sum of the 4 items below it and $2,244,280.
The next set of numbers (the $371,951) should be the sum of the 4 items below it and $1,295,365 and finally the last total row should be the $2,244,280 + 1,295,365 = $3,539,645
Right now the formula is working correctly but not at the aggregated area so I know I need to change my formula but not sure how.
Any ideas!
Anonymous I think it should be SUMX iterate over your column on the rows
New Measure = SUMX ( VALUES ( Table[Column On The Row] ), [Total Sales Diff Per Week Measure] )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
2 Replies
Anonymous I think it should be SUMX iterate over your column on the rows
New Measure = SUMX ( VALUES ( Table[Column On The Row] ), [Total Sales Diff Per Week Measure] )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
hi Anonymous
This is a measure totals problem. Very common. See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376or
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907you just create another measure by SUMX as parry2k's said. If you still have problem, please share your sample pbix file.
Regards,
Lin
