locked
Modifying formulas at the same time RRS feed

  • Question

  • If you have 20 measures in a table, and you want to add a filter to all of them, for example, only on this type of category of claims, is there a quick way to do that with measures or is it better to just the filter in the pivot table itself? Here is an example: 

    Total Claims YTD:=TOTALYTD([Claim Count],DateTable[Date])....I have a ton of formulas relating to claims count, but now I want to say only claims with a certain status. 

    In general, it is difficult to copy and paste measures in Power Pivot. Is there a way around this? 

    Saturday, September 3, 2016 2:32 AM

Answers

  • It's better to just filter the pivot table itself if that's an option.

    There is no easy way to bulk edit calculations


    http://darren.gosbell.com - please mark correct answers

    Thursday, September 22, 2016 3:24 AM
  • If you've built up your collection of measures in a nice, clean way, as you seem to have done (your 'ton of formulas' all based on [Claim Count]) you should be able to add this filter to the [Claim Count] measure and all others will follow. Be careful, however, with nested calculations that change filter context - adding a filter to the base measure (as a last step in the calculation, in fact) may eliminate earlier filters you've set in some of your 'ton of formulas'...
    Thursday, September 22, 2016 6:12 PM
    Answerer

All replies

  • It's better to just filter the pivot table itself if that's an option.

    There is no easy way to bulk edit calculations


    http://darren.gosbell.com - please mark correct answers

    Thursday, September 22, 2016 3:24 AM
  • If you've built up your collection of measures in a nice, clean way, as you seem to have done (your 'ton of formulas' all based on [Claim Count]) you should be able to add this filter to the [Claim Count] measure and all others will follow. Be careful, however, with nested calculations that change filter context - adding a filter to the base measure (as a last step in the calculation, in fact) may eliminate earlier filters you've set in some of your 'ton of formulas'...
    Thursday, September 22, 2016 6:12 PM
    Answerer