Keep measure static

[criecher]

I have a measure, 2017 Monthly % Share (2017 Monthly % share = DIVIDE('Contracts'[2017 Contracts], CALCULATE('Contracts'[2017 Contracts], ALLEXCEPT('Contracts', 'Contracts'[Date])), 0))

This works great when looking at the entire nation's information.  If I select one of our regions, in a slicer, the values change. 

I understand why it's changing, but formulas put against this measure then change as well, creating discrepancies.  Is there anything I can do to keep them as they were prior to the slicer being selected.  I need the original values to perform another calculation.

[Anonymous · Accepted solution]

Hey @criecher

Could you try making this a calculated column instead of a measure? This would only be calculated when the report is refreshed instead of each time a slicer is selected.

Hope this helps,

Parker