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,

 

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

hidenseek9's avatar
hidenseek9
Post Patron
8 years ago

Ashish_Mathur

 

Here is a simplified version of the sample data.

I have also attached the answers to the questions in the file already.

 

Sample Data

 

Basically, I would like to calculate the following in PowerBI

  • Air Jordan Distribution (Brand)
  • Air Jordan 1 Distribution
  • Air Jordan 2 Distribution
  • Carmelo Distribution (Brand)
  • Carmelo 1 Distribution
  • Carmelo 2 Distribution

 

Many thanks,

 

H

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    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.