Using the ALL function when there is grouping or subgroup

[yenyengo7]

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	23
Product 3	6	23
Product 4	8	23
Total	23	23

But when I merged it with another table to view Category, the Tolal Volume LY now change to below. How do I keep the Total Volume LY to remain at 23 same as above table?

Product	Category	Volume_LY	Total Volume LY
Product 1	Protein	5	9
Product 2	Protein	4	9
Product 3	Produce	6	14
Product 4	Produce	8	14
Total		23	23

[yenyengo7]

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. 

[thiagocamillo · Accepted solution]

Try,

Total Volume LY = 

   CALCULATE(

             Sum([Volume_LY]), 

                ALL([Product],

                ALL([Category]

)

[yenyengo7]

I mean Total Volume LY to remain at 23 in all lines or products.