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
Community Champion
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you themistoklis!

    What if I want to add another slicer for the products?

    • themistoklis's avatar
      themistoklis
      Community Champion
      7 years ago

      Anonymous

       

      Can you please explain further what you are trying to do with the new slicer?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        themistoklisWell, your measure works for calculating the share of the products from the calculated column but when I select a product from that column from a slicer it seems to divide itself and the result is always 100%. What I want is to have a product slicer where, when i select some of the products from that category, it shows their share.