Forum Discussion

ninapetr's avatar
ninapetr
Regular Visitor
2 years ago
Solved

Weighted Average (Aggregate weight by category)

Hello! I have the sense that this is very simple, but I'm struggling with this. That are a set of KPIs for each Management Unit, each KPI has it's own weight and a score (grade) that, in the end, w...
  • lbendlin's avatar
    2 years ago

    use REMOVEFILTERS(KPI) for that.  Note that the approach will be different depending on if you want this to be a calculated column or a measure.