Forum Discussion

BUC's avatar
BUC
Frequent Visitor
2 years ago
Solved

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    2 years ago

    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 Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.