Scorecard Metrics - Linked Submetrics AVG

[Lemysterieux]

Hi! 

We are working with scorecard metrics, and have succesfully linked metrics for two areas into one department. 

Thou when using the "use submetrics" and AVG, it shows the sum (see marked in red below). 

Next milestone should be  ~121 by the "use submetrics AVG", but now shows the sum of the submetrics. 

Is this just an error, or something I might have missed when using linked metrics? 

[Anonymous]

Hi @Lemysterieux ,

Please troubleshoot the following factors:

1. If you filter your scorecard by a hierarchy, linked metrics aren't filtered. They continue showing their original value. Check-ins to linked metrics aren't allowed on a hierarchical child scorecard.

2. If you link a rollup metric onto a different scorecard, it continues to show its calculated value from the source scorecard and doesn't take into account any child metrics on the destination scorecard. Additionally, if a linked metric is the child of a rollup metric, it's not included in the parent's calculation.

3. Rollups always show the same aggregation value of all submetrics, regardless of metric level permissions. This means if person A only has view access to 3 out of 5 submetrics, they still see the same parent metric value as someone who has access to all submetrics.

Refer: Create linked metrics in the Power BI service - Power BI | Microsoft Learn

Create submetrics in the Power BI service - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.