Issue pulling previous to current month item quantities

Hi Anonymous ,

The top formula works, but it only works for the row. You add All at the next formula so you got the result you wanted. There are some difference between the measures and columns.

An important difference between measures and calculated columns is that measures are evaluated in the filter context of the visual in which they are applied. The filter context is defined by the filters applied in the report such as row selection, column selection, report filters and slicers applied. Measures are only evaluated at the level of granularity they are plotted at. As calculated columns are computed when you first define them/ when you refresh your dataset, they do not have access to the filter context. Calculated columns are calculated outside of the filter context and do not depend on user interaction in the report.

More details : What is the difference between a measure and a calculated column? 

I have also found a useful blog, please refer to it to see if it helps you.

When to Use Measures vs. Calc Columns 

 Best Regards
Community Support Team _ Polly

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