Forum Discussion

iBusinessBI's avatar
iBusinessBI
Kudo Collector
4 years ago

Calculation Group for altering a measure

I have a large model with lot's of measures.
Now I have to add some records to this model that I don't want to influence my measures by default.
Only if the users desire, they can choose to see the measures with the new records.
So I thought to create a calculation group with something like
CALCULATE(SELECTEDMEASURE(),KEEPFILTERS(Table[RecordType]<>"New Record"))
But how do I make it apply on all the existing reports by default?
And I don't mean just adding it to "Filters on all pages", I have lots of pivots connected to the dataset via "Analyze in excel", I don't want to change anything there...
Please help. Maybe other solution?