Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Average by a group

Hi,  I've tried more than 20 other solutions on similar problemt - none have worked so far.    I want to create a measure calculating the average category value share for each chain of stores (a...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Siva,

When using the average function it does not recognize the category value share measure.

SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Anonymous, Is it already a measure? If yes, the AVERAGE function doesn't require 

 

calculate([category value share],ALL(table1[store]))
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi again,

    The table shown in the example is the end-product which i seek to asctertain.

    Currently i have calculated the category sales value as follows:
    = (Divide(sales,totalsales))*(divide(totalsales/category value))

    It is calculated per store and sums as intended to the given hierarchy of chains and wholesalers. I simply need to compare the individual store average to the average of the chain of stores to which it belongs. Example: a store may have a category share of 10%, whilst the average of all the stores within that chain is 15%. This one store is then underperforming and has an initial growth potential of 5%. 🙂

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Upon using your measure i get the following:

      I need every store to take the average of the chain ("Bilka" in this case)

      • SivaMani's avatar
        SivaMani
        Icon for Resident Rockstar rankResident Rockstar
        5 years ago

        Anonymous, It should work. I hope Bilka is just another value under the chain column.

         

        If possible, share the pbix possible. will have a look.