Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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 )
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 )
themistoklis,
Worked perfectly! Thank you very much. I shall keep your formula within close reach for future challenges. 🙂
/depple
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |