Forum Discussion
Aggregation - New Table or Measure
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