Forum Discussion

depple's avatar
depple
Helper III
7 years ago
Solved

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 co...
Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    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's avatar
themistoklis
Community Champion
7 years ago

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 )
depple's avatar
depple
Helper III
7 years ago

themistoklis,

 

Worked perfectly! Thank you very much. I shall keep your formula within close reach for future challenges. :-)

 

/depple