Forum Discussion

pmstahl's avatar
pmstahl
Frequent Visitor
2 years ago
Solved

Trailing 12 Month YoY % Comparison

Goal: Show a percentage by month that compares the rolling 12 month sum to the prior year's 12 month sum.  Examples: For 2024-06, the current 12 month sum is 3195. The previous year's 12 mont...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.