Trailing 12 Month YoY % Comparison

Hi pmstahl 

According to your description, the result is incorrect due to data loss after using the filter. This may have something to do with the filter criteria you used when creating measure.

To ensure that the calculation is not affected by the slicer, use or ignore the slicer context in the measure. For example,

All: Ignore all filters.

Measure = CALCULATE(SUM('Table'[values]), ALL('Table'))

If you still have problems, it is best to provide the pbix file and be careful to delete sensitive data.

Regards,

Nono Chen

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