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 am having a difficulty calculating average price of all of our products per store per month.

Please find below as the data.

Sample Data

 

What I want to do is simple.

I would like to calculate an average price of each product for each brand by store.

Also is there a visual to show an average price as well as the lowest and highest price of the average??

(Like Stock Price Ticker?)

 

Your help is much appreciated.

 

Many thanks,

 

Hide