Forum Discussion
Row Subtotals Not Adding Up
Please see below. For some reason the weight wasted and wasted value are not adding up (what's in the screen grab is everything there). I think it may be something to do with the fact that the two incorrect columns are calculated (wasted weight is weight x item decrease count) and value is item cost x decrease count. Any ideas how I can make the totals just add up what's on the screen?
BUC , You can try measure like this based on visual column/row/axis field
If one column is not summarized
Sumx(Values(Table[Column]), [Your measure] )
More than one column
Sumx(Summarize(Fact, Dim[Col1], Dim[COl2]), [Your measure] )
Also refer: https://www.youtube.com/watch?v=ufHOOLdi_jk
Hi BUC ,
You can use the sumx function for cumulative summation. Refer to the following demo:
m_ = CALCULATE ( MAX ( 'Table'[Value] ), FILTER ( 'Table', 'Table'[Status] = "Pass" ) )total_ = SUMX('Table',[m_])Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
BUC , You can try measure like this based on visual column/row/axis field
If one column is not summarized
Sumx(Values(Table[Column]), [Your measure] )
More than one column
Sumx(Summarize(Fact, Dim[Col1], Dim[COl2]), [Your measure] )
Also refer: https://www.youtube.com/watch?v=ufHOOLdi_jk
Hi BUC ,
You can use the sumx function for cumulative summation. Refer to the following demo:
m_ = CALCULATE ( MAX ( 'Table'[Value] ), FILTER ( 'Table', 'Table'[Status] = "Pass" ) )total_ = SUMX('Table',[m_])Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.