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 w...
  • 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

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