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.

     

hidenseek9's avatar
hidenseek9
Post Patron
8 years ago

Hello Power BI Community,

 

I have a question regarding understanding distribution of a product at store level.

Please find below as a sample data

Sample Data

 

Data has a list of stores that sell certain products and our employees go to a store to check the price on shelf.

Sometimes, the price check happens multiple times a month.

 

What I would like to understand is that at any given month,

in how many stores each product is sold.

That way, I can understand the distirbution trend of our product over time.

 

Appreciate your support.

 

Many thanks,

 

H

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