2 Replies Latest reply on May 24, 2017 6:44 AM by Jason Larson

    Lock measure when filtering to calculate % of original value

    Jason Larson

      Hello,

       

      I am looking to lock a measure from being filtered in a worksheet to show a % of the original payment for different regions. I duplicated the "Payments" measure because I am trying to calculate SUM(Payments) / SUM(Payments(copy)). So any help with keeping Payments(copy) a constant value and not change when filters are applied would be great.