Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Creating a market share

Hi Guys,   I want to create a market share type of measure but i have i bit of a complicated and large data.   I thought of using a measure where i divide the selected data from me by another sel...
Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    Anonymous

     

    Create a measure like the following:

    % Share = 
VAR Volume =
    SUM('Table'[Sales])
VAR AllVolume =
    CALCULATE ( SUM('Table'[Sales]),ALL('Table'[Calcuated_Column]) )
RETURN
    DIVIDE ( Volume, AllVolume )

    And then create a new Table object and add your calculated column as dimension and next to it add then above measure

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous

 

I dont see the same behaviour when i recreate it on PowerBI.

 

When i select something from the slicer then the table shows me the share of this product across all the products and not of its own.

 

Any chance to share your file or show with couple of images the desired output?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

themistoklis Thanks, but i've managed to work it out, by adding an "ALL Filter in the calculation of the category.

Thank you again for your time!