Weighted Average (Aggregate weight by category)

[ninapetr]

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, will make the final grade for each Management. So, it's an weighted average.

My problem is that when I put the column WEIGHT TOTAL MANAGEMENT on my PBI table, it doesn't show the aggregate value of the management weights, it shows only the weight for each KPI. In that way, I can't do the division for the weighted average. Please, help!

[lbendlin · Accepted solution]

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.