Forum Discussion

mayanknamasys's avatar
mayanknamasys
Regular Visitor
2 years ago

Weighted Average in Sub Metrics

Hi everyone,   Metrics in Power BI Service gives us the option to create sub-metrics. I see that there are 4 roll-up options to calculate the option of a Metric from Sub Metric which are Sum, Avera...
Need Help
mayanknamasys's avatar
mayanknamasys
Regular Visitor
2 years ago

Thanks for responding. I understand that calculating the weighted average is possible in DAX but to achieve this, I will have to maintain a separate data source for KPI weights. I was interested to see if it is possible to allocate weights to Sub Metrics itself. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mayanknamasys ,

 

Rollup submetrics give you the flexibility to specify how you want your data aggregated. Your data can be aggregated ranging from percent completed, to weighted averages, to overall sums. You can use these rollups to measure progress toward an overall goal.

Refer: Create submetrics that roll up to the metric | 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. 

  • mayanknamasys's avatar
    mayanknamasys
    Regular Visitor
    2 years ago

    Thanks again. I have gone through that documentation and I know weighted average is mentioned there. But I don't find any way in the Power BI Service to add a weight to sub metrics. There is only option to add targets and actuals. That's why I am not sure if it is possible.