Forum Discussion
Solved
Weighted AVG Aggregation
Hi, I got a problem when creating a calculated member in PowerBI. Here is the sample data: Category Product Sold Total 1 1 123 4444 1 2 0 0 1 3 3 66 2 4 1 2 2 ...
Hi joeguan,
In your scenario, please create a measure instead of a calculated column like below to calculate rate:
Rate = DIVIDE(SUM(Sheet3[Sold]), SUM(Sheet3[Total]),0)
Then create a matrix visual, place Category and Product in Rows, Sold, Total and Rate in Values.
Best Regards,
Qiuyun Yu
Hi joeguan,
In your scenario, please create a measure instead of a calculated column like below to calculate rate:
Rate = DIVIDE(SUM(Sheet3[Sold]), SUM(Sheet3[Total]),0)
Then create a matrix visual, place Category and Product in Rows, Sold, Total and Rate in Values.
Best Regards,
Qiuyun Yu
Hey Qiuyun, As I mentioned, if I use your formula, every single row shows 18.9%(the grand total number). I can't make a filter on category column though. Because it is always 18.9%...