Forum Discussion
Solved
Plot Weighed Average
Hi, I am new to Power BI. I need to plot the weighted average of the price over several regions for one customer vs. time. How can I so this? I am providing a hypothetical sample table. I want to...
this turned out to be very easy. I bascially created a new measure = sum of price / sum sales. When plotting, Power BI does the averagin over the relevant category depending on what category I use in the plot.
Hi MOMOMO ,
Please refer to how to calculate the weighted average with DAX.
Power BI Weighted Average and Totals – Simplify Power BI
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thanks but this did not adress my issue.