Skip to main content

Power BI

New

Power BI Metrics - Sub Metric Roll Up Target based on a % target or a calculated column and have weightings applied

Vote (1) Share
Alan Teal's profile image

Alan Teal on 21 Dec 2022 10:47:25

With sub metrics you could have 2 sub metrics one with a target of 100% and the other based on 50%. When reviewing the rolled up score it would be out of 150%.


This has 2 issues.

One it means the first submetric has twice the weight of the second list.

Secondly it doesn't make sense for the user as your target is 150%. It would be better if you could allow a score to be used so when you hit 50% for the second one you are 100% of your target and when you hit 100% for the first example you are of course 100% of your target.


Therefore the rolled up target could then be based on 100%


Also having the ability for the sub metrics to be weighted and taken account in the target would be useful.