Forum Discussion

MOMOMO's avatar
MOMOMO
Frequent Visitor
5 years ago
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...
Need Help
  • MOMOMO's avatar
    MOMOMO
    5 years ago

    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.

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

MOMOMO 


Can you share the expected results as well?

  • MOMOMO's avatar
    MOMOMO
    Frequent Visitor
    5 years ago

    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.