Forum Discussion
Aggregation - New Table or Measure
First, I am a Power BI novice and please bear over with my scattered skills.
I have a Table with the following columns:
Week | Supplier | Store | Manufacturer | Sales
As there are many combinations of Supplier Chain, Store and Manufacturer, there are multiple rows per week.
1. How do I aggregate the weekly sales for each manufacturer?
2. The output is to be presented in a line chart. Should this be done in a new table or measure?
Thanks in advance for any help.
/depple
Create this new measure and add it on Values area in the graph:
% Share = VAR Volume = SUM('Table'[Sales]) VAR AllVolume = CALCULATE ( SUM('Table'[Sales]),ALL('Table'[Manufacturer]) ) RETURN DIVIDE ( Volume, AllVolume )
4 Replies
themistoklis,
Thank you for your quick suggestion!
That was an easy solution. I am obviously not familiar with the capabilities the software.
And now, trying to display the manufacturer market share per week, I do however notice that "Show value as" => "Percentage of Total" (my translation from non-English version) is not showing up the way I would hope, but that is probably because is shows market share for all data points, instead of per week. Could you point me in the right direction for how to display per week market share? Would this be the time for a measure or new table?
Thanks in advance.
/depple
Create this new measure and add it on Values area in the graph:
% Share = VAR Volume = SUM('Table'[Sales]) VAR AllVolume = CALCULATE ( SUM('Table'[Sales]),ALL('Table'[Manufacturer]) ) RETURN DIVIDE ( Volume, AllVolume )
