Forum Discussion
Weighted average
Hello, in my data i have a column named ETICHETTA which contains the row headers of the photo, I've been using a measure that calculate the average for RES Share and the SUM for everything else but now i have to change that code to calculate a weighted average for RES Share and still a SUM for every other row
My underlying data have a daily granularity and i have to calculate the average of RES Share by using Rinnovabili as the weight. Do someone know how to do it? I've been trying but since both of the values are in the same column I couldn't make it since it would just say that it's 0
1 Reply
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
