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,

 

I get a message saying that the file size exceeds 5MB.  Thereafter there is no option to download.

  • 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.