Hey guys, I have a very big table with 3 dimensions and 13 measurements. One of these measurements is this particular formula, let's call it [PointCalculation]:
Sum(TOTAL Aggr({<[Packed]-={''}>}Sum([Points]),[Packed],[ID]))
The formula calculates a total of points from a given dataset (which works fine on it's own), but i want the value to stay at the same value after filtering.
So when [PointCalculation] = 500 and I filter the table, it should stay at 500 regardless of the filter.
(What happens right now, it drops to a value below 500. This affects the other 12 measurements as they are based on it)
I have tried some set analysis syntax but it doesn't produce the wanted result.
