Fix expression (independent from table selection)

nm02 — Thu, 13 Jul 2023 20:33:21 GMT

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.

topic Fix expression (independent from table selection) in App Development

Fix expression (independent from table selection)