Forum Discussion

criecher's avatar
criecher
Frequent Visitor
8 years ago
Solved

Keep measure static

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's avatar
    Anonymous
    8 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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