Forum Discussion

yenyengo7's avatar
yenyengo7
Frequent Visitor
4 years ago
Solved

Using the ALL function when there is grouping or subgroup

I have created a measure with below DAX Total Volume LY = CALCULATE(Sum([Volume_LY]),ALL([Product]))... it works okay. Product Volume_LY Total Volume LY Product 1 5 23 Product 2 4 ...
  • thiagocamillo's avatar
    thiagocamillo
    4 years ago

    Try,

     

    Total Volume LY = 

       CALCULATE(

                 Sum([Volume_LY]), 

                    ALL([Product],

                    ALL([Category]

    )

yenyengo7's avatar
yenyengo7
Frequent Visitor
4 years ago
Can you please help me understand why below DAX does not work?
Total Product Days LY (Rate) = CALCULATE(Sum(Monthly[Product_Days_LY]),ALL(Monthly[Rate Segment]))

I need the Total Product Days LY (Rate) to be 4,366,472 across all Rate Segments.