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