Forum Discussion

hidenseek9's avatar
hidenseek9
Post Patron
8 years ago
Solved

Calculating average price using distict count??

Hello Power BI Community   I am having a difficulty calculating average price of all of our products per store per month. Please find below as the data. Dummy Data   What I want to do is simple...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi hidenseek9,

     

    Try these formulas

     

    Count=DISTINCTCOUNT(Data[Store])

    Contribution (%)=[Count]/CALCULATE([Count],ALL(Data[Brand]),ALL(Data[Product]))

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi hidenseek9,

 

You say that you want to know in how many stores each product is sold?  In your dataset, i see Product Name but i do not see any Store Name column.  Please show the exact structure of your expected result.

hidenseek9's avatar
hidenseek9
Post Patron
8 years ago
Ashish_Mathur

Tempo data in column A is the store name

Appreciate your help

Many thanks

Hide
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi hidenseek9,

     

    Please share the exact structure you are expecting in the final result.

    • hidenseek9's avatar
      hidenseek9
      Post Patron
      8 years ago

      Ashish_Mathur

       

      What I would like to know is below on any given month.

      1. A total number of stores checked. (i.e. Brand A: 200 stores, Brand B: 300 stores,...All Brand 1000 stores)
      2. A total number of stores that each product is sold. (i.e. Brand A Product Name 1: 50 stores, Brand A Product Name 2: 100 stores, etc.)
      3. Distribution of each product in percentage. (This would be 2 / 1 (A total number of stores checked for all brands)

       

      Many thanks,

       

      H

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        When i try to build a Pivot Table, i get the same number of stored checked for all brands.  There is something wrong with the dummy data that you have shared.  Share a smaller dataset and with respect to that smaller dataset, share the expected result (show actual numbers that you are expecting there).