Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter context using MAX

Hi,   I'm using this pbix file https://ufile.io/8gy9deoz and I'm using the following equation to find the cumulative total. I'm confused because max('Product'[Date]) appears to find the maximum Pro...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous I guess this will answer your question if you change your measure as below.

     

    CALCULATE(sum('Product'[Volume]), 
FILTER(
all('Product'),
    'Product'[Date] <= CALCULATE( max('Product'[Date]) )
)
)
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous I guess this will answer your question if you change your measure as below.

 

CALCULATE(sum('Product'[Volume]), 
FILTER(
all('Product'),
    'Product'[Date] <= CALCULATE( max('Product'[Date]) )
)
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks parry2k I think the penny's dropped. So ALL doesn't change the filter context of the whole of the calculate statement, just for the table expression used for iteration (not sure if iteration is the correct word!)

     

    Thanks,

     

    CM